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.
N4993NBryant Kenneth D · Black Diamond, WAN4994ARose Carey V · Colville, WAN4994FClark William R · Anchorage, AKN4998AWright Transport Inc · Colfax, INN4998DWood Andrew A · Clifton Springs, NYN4998USixty Five Two Ten LLC · Oak Island, NCN4999DMielke Martin W · Valley City, OHN4999PPaul Bonnie Jean · Del Rio, TXN499ETQualitair LLC Owner Trustee · MichesltadtN499KCopper River Airmotive LLC · Copper Center, AKN499MMBrown George P III · Houston, TXN499SCurcio Joseph A · Granite Bay, CAN499WLMatthews Joseph D · Farr West, UTN49FCPiedmont Aviation Leasing LLC · Monticello, GAN49GLBobo Robert A · Pullman, WAN49GPMartin Dale · Lubbock, TXN49JSN49js LLC · Missoula, MTN49JTBell Steven M · Wasilla, AKN49STHedeen Arnold R · Seattle, WAN49USUnited States Aviation Underwriters Inc · Addison, TXN4AHHand Kevin D · Anchorage, AKN4BEMehrer Kelly · Apex, NCN4CGAffordable Avionics Ind DBA · Chino, CAN4DXHuffman Aviation & Equipment LLC · Marietta, GAN4ECPhantom Five Inc · Saint Louis, MON4FPWareham Darryl V · Mill Creek, WAN4GLWest Christina · Missouri City, TXN4KKAnderson Rodney L · Pilot Rock, ORN4KXHorseshoe Bar Land & Livestock LLC · Gillette, WYN4LFMacys Flying Service Inc · Tulelake, CAN4LTRegistered aircraftFirst renewal noticeN4MWTl Aviation LLC · Jonesboro, ARN4NBGreenslip Aviation LLC · River Falls, WIN4RGMayer Gordon · Dallas, TXN4RMLofgren Kenny G · Redmond, ORN4RQJ&P Aero LLC · Corsicana, TXN4UAAnchorage Community College · Anchorage, AKN4URN4ur LLC · Comanche, TXN4USDees Aviation LLC · Paragould, ARN4UWOsterholt Enterprises LLC · Kailua Kona, HIN4VWPronk Glen R · Crittenden, KYN4WQKittinger Aviation LLC · Calhoun, KYN4WSZeller Robert A · Oro Valley, AZN4WWWarren Gregory C · Redmond, ORN4YTMclaren Paul E · Pensacola, FLN4YVDonnie Young Farms Inc · Ulysses, KSN4YYWilliams Scott Griffin · Salt Lake City, UTN4YZLackerdas Harry · Melba, IDN50008Osowski Wes A · Kodiak, AKN5001DTatter David W · Kingman, AZ
Back to AD 84-10-01 R1