AD 87-10-06 R1
Registered aircraft · 72,010
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7282ZSimmons Aviation Services LLC · Pawcatuck, CTN7284CSeed Richard J IV · Wicomico Church, VAN7284GFisher Global LLC · Faulkner, ARN7284JGiermek Peter T · Olean, NYN7284LGriffin Alvin G · Mechanicsville, MDN7285FKulp Clayton H · Wichita, KSN7285LMurrell David Tyler · Pensacola, FLN7286CWalker David L · Louisville, KYFirst renewal noticeN7286LCover George A · Thayer, MON7286QLacombe Bryan K · Rockwall, TXN7286WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN7286YReagan Scott Lllp · Mount Pleasant, SCN7287GTen Mile Ranch Inc · Vale, ORN7287JJames Leroy R · Renfrew, PAN7287KClapp Carl W · Edmonds, WAN7287PTwo Dot Aircraft LLC · Kalispell, MTN7287WLebouef Kelly J · Rayne, LAN7287ZQuality Aviation Inc · Marana, AZN72884Hawkeye Aviation LLC · Miami, FLN7288FJ&S Aeronautics LLC · Mcgregor, TXN7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeN7288WIndependence Youth Flying Club Inc · Independence, ORN7288YN7288y LLC · Manassas, VAN7289JValdez Jose C · Troy, MIN7289KIberlin Christian J · Gillette, WYN7289LMott Calvin L · Rolla, MON7289WHarris Clark R · Tribune, KSN7289ZWerth John F · Hays, KSN728AMeridian Aircraft LLC · Wilmington, DEN728AABrinckerhoff Allen D · Windermere, FLN728BLRamey Dale J · Atascadero, CAN728CAPremiere Aviation Inc · Wilmington, DEN728CMSchweitzer Gregory M · Tabernacle, NJN728DBStyer David B · Pendleton, ORN728DFExplore Helicopters LLC · Lexington, ALN728DMForkel Stephen P · Bend, ORN728EBeaver Companies LLC · Shelby, NCN728FLFalcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedN728GLMartin James D · Graford, TXN728HRVelasco Higareda Ignacio L · Valencia, CAN728JWMagnusson Dwayne · Anchorage, AKN728KGCapsed LLC · Mojave, CAN728NDUniversity Of North Dakota · Grand Forks, NDN728PHornsby Mark · Jackson, LAN728RTBurnside Jack · Rockwall, TXN728TBAtd Pilot Training LLC · Kansas City, MON728TSSky King LLC · Baltimore, MDN728WVeldman Richard D · Laporte, INN728WFReigh Galen R · Williamsburg, PAN728ZIrizarry Eduardo F · Columbia, SC
Back to AD 87-10-06 R1