AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N9538ENorthwoods Air LLC · Orono, MEN9538XTodd Robert L · Alvarado, TXN9539DBohemia Aviation LLC · Niagara, WIN9539HNorthwest Flyers Inc · Marianna, FLN9539LSt Pete Aviation Services LLC · Saint Petersburg, FLN9539PNichols Aviation LLC · Middletown, DEN9539RAdams Scott A · Glenview, ILN953CCScruggs Ken · Plain City, OHN953RRGig Aviation LLC · Harrisburg, ARN953STBoone Keith · Cabot, ARN9540TChino Aviation Inc · Chino, CAN9540XWhitetop Air LLC · Wilmington, DEN9541BBodick John K · Anchorage, AKN9541TNevill John D · Tahoka, TXN9542TLarsen Richard A · Wannaska, MNN9542WState Of North Carolina · Raleigh, NCN9543FEvans Michael · Punta Gorda, FLN9543GHi Low Aviation LLC · Alpine, TXN9543XBarth Samuel · Fonda, NYN9544QPhoto Services Unlimited · Augusta, MEN9544SJourney Holdings LLC · Reform, ALN9544XB&B Aviation LLC · Arlington, WAN9545XRichardson Dana C · Okeechobee, FLN9546GSale Reported · Emerson, IASale reported, canceledN9546TAerographics Inc · St Cloud, MNN9546XN9546x LLC · Lakeville, MNN9547XCundiff Zackery A · Klamath Falls, ORN9548XMclenaghan Alvin · Phoenix, AZN95494Valiair Limited Co Trustee · Casper, WYN9549GMacica Stephen J DBA · Truckee, CAN954CCSavvas Evangelos · Edina, MNN954PWWeckbacher Paul J Jr · Inverness, FLN95500Pond Scott L · Moorpark, CAN9551WBcbc Aero Services LLC · Dover, DEN95521Martin Aviation LLC · Kalispell, MTN95528Welch Clare A · Longboat Key, FLN9552RCauv LLC · Cincinnati, OHN9553SHunters Adventures LLC · Kennesaw, GAN9553XMccarthy Sean P · Jacksonville Beach, FLN95540Gracejet Aviation LLC · Brownsboro, TXN95541Pershing Air LLC · Sheridan, WYN95544Keller Lucas J · Vale, ORN9554GMorse Donald · Priest Lake, IDN9555XWalker Scott · Mammoth Lakes, CAN9556ZIsland Aircraft LLC · Anchorage, AKN9557PHendrix Steven · Bakersfield, CAN9557XCivil Air Patrol Inc · Maxwell Afb, ALN9558BGrap Jeffrey G · Statham, GAN9558TWatson Stephen C · Flemingsburg, KYN9558XWagner Larry D · Raleigh, NC
Back to AD 84-10-01 R1