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.
N9103XBeechit LLC · Prescott, AZN9104CPerkins Randy S · Great Falls, MTN9104MRufe Preston · Geneseo, NYN9104TPeninsula Aeroworks LLC · Fife, WAN9104XWoods William M · Ochelata, OKN91055Murray Joshua S · Camas, WAN91060Second Wind Aviation Corp · Friday Harbor, WAN91066King D Kenyon · Chatham, NHN9106CUpper Valley Flying Club Inc · White Riv Jct, VTN9106MWeekley Marlin · Metamora, ILN9106XCollinsville Design LLC · Newington, CTN91078T Or M LLC · Brentwood, TNN9107CCagle Holdings LLC · Jenks, OKN9107MBurns Robert L · Bremen, GAN9108GLeder John A · Marble, NCN9108MHorinek Dave L · Goodland, KSN9108XDighans Michael J · Peerless, MTN9109GVess David G · Gaffney, SCN9109XUplift Aviation LLC · Dover, DEN910HPState Of Ohio · Columbus, OHN910LFNby Productions · Bristow, VAN9110XCoffman Ryan S · Marysville, WAN91116Adventure Airways Inc · Homer, AKN9111MSierra Air LLC · Willow, AKN91121Central Illinois Aviators Inc · Galesburg, ILN9112CCk Jet LLC · Hillsboro, MON9112GPomeroy Vincent Lee · Anchorage, AKN9112MJlck LLC · Jordan, NYN9112XSorenson Chad · Soldotna, AKN9113MGospel Ministries International Inc · Collegedale, TNN9114XDk1 Aviation LLC · Fayetteville, NCN91156Scarlett Ryan Jay · Sparks, NVN91157Garza Aircraft Inc · Harlingen, TXN9115THigginbothan Stewart C · Woodbine, GAN91160Brown Jeffrey C · Saint Augustine, FLN91162Kelley Patrick J · Catawba, NCN9116GJones Brian E · Painted Post, NYFirst renewal noticeN9116XTaylor Aviation Inc · Fort Benton, MTN91170Paklook Air Inc · Bethel, AKN9117CRegistered aircraftN9117GAndrews Mimi Muldrow · Hilltop Lakes, TXN9117MPettigarrett LLC · Manchester, GAN9117TMichaud Paul K · Forest Lake, MNN91183Hatch Hyrum G · Gilbert, AZN9118CWalter Tina R · Yorkville, CAN9118THagen Bruce L · Reeder, NDN91190Renfro Michael W · Bethel, AKN91199Olmstead Daniel H · Kimberly, IDN9119GWinters Richard Linn · Chandler, AZN911BWOlsen Garry O · Forest Lake, MN
Back to AD 84-10-01 R1