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.
N942CABaca Flavio Tomas · Vail, AZN942EAngry Manx LLC · Riverside, CAN942FLJochnma Steven J · Aumsville, ORN942JFLuke James Michael · Austin, TXN942LBWade Ronald · Lake Stevens, WAN942LCRegistered aircraftN942PTGarboden Patrick N · Katy, TXN942RBJf Aviation LLC · Minot, NDN942TBillen Jarod H · Lakeland, TNN942TALost Squadron Inc · Wilmington, DEN942TBBailey Thomas R · Benton, KYN942TECardinal Enterprise LLC · Jackson, WYN942VTMcintosh Donald W · Sandpoint, IDN942WDHemdmm Corp · Wilmington, DEN9430NOakley Air LLC · Oakley, MIN9430PBonn Fred H · Jamestown, KYN9430VRuff Deborah · Auburn, CAN9430W3zero Whiskey LLC · Newport Beach, CAN9431COsgood Air LLC · Ransom, KSN9431JCurrie Kenneth Edward · Lumberton, NCN9432DRegistered aircraftN9433DPacer Flight LLC · Huron, OHN9433EKozma Peter · San Diego, CAN9433JSierra Delta Aviation Services Inc · Middletown, DEN9433LCivil Air Patrol Inc · Maxwell Afb, ALN9433WSanford William M · Olalla, WAN9434JSchmidt Matthew F · River Falls, WIN9434PSheehan James A · Newberg, ORN9434VKnackstedt Dennis R · Winfield, KSN9434WJohnson James E · Calhoun, LAN9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeN9435JHarmon Daniel J · Sheridan, INN9435NDoran Jeffrey · Centerburg, OHN9435PWahl John B · Pendleton, ORN9435WPace Lawrence W · Westminster, CON9436PWarren Michael W · Wiscasset, MEN9436WGiesbrecht Harley L · Deridder, LAN9437DRichmor Aviation Inc · Scotia, NYN9437JGarba Ibrahim I · Boulder City, NVN9438DWeidner Kevin G · Bunker Hill, ILN9438HBering Capital LLC · Anchorage, AKN9438PZimmerman Kyle R · Gilbert, AZN9438VPrestridge Jacob · Portland, ORN9439BAv Dak Inc · Crystal, NDN9439ESilverhawk Aviation Academy LLC · Caldwell, IDN9439HTreichler Peter DBA · East Aurora, NYN9439KAirspeed Marketing Bravo LLC · Phoenix, AZN9439WCherokee Ltd LLC · Mesa, AZN943GDowning John Brent · Castro Valley, CAN943HSMonika Aviation LLC · Humble, TX
Back to AD 87-10-06 R1