AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.
N8468YStone D L · Arlington, TXN846PAfonso Joseph · Wallkill, NYN8474PCopass Benjamin J · Fountain Run, KYN8475PBlackdog Air LLC · Wilmington, DEN8475YSolymossy Robert A · Tysons, VAN8477PD F Osborne Construction Inc · Topeka, KSN847BRegistration Inc · Kalispell, MTN847EDFoster Matthew R · Poplar Grove, ILN847NDUnd Aerospace Foundation · Grand Forks, NDN847SPRothschild Joel S · Crestline, CAN8480PGlaser Violet E · Calhan, CON8481PBailey Roger R · Mineral, TXN8482PHogan John Robert · Palm Beach Gardens, FLN8483PHigh Wing Aviation LLC · Sardis, MSN8486PHaawq Air LLC · Brookshire, TXN8486ZKlompstra John V · Wadsworth, OHN8487YAviation Safety Dynamics LLC · Richmond, TXN8489YSorbi Aviation Inc · El Cajon, CAN8491DDirty Side Down LLC · Downers Grove, ILN8491PHansen Jed D · Clark, SDN8492YGaipa Timothy A · Saint Joseph, MIN8493PKeystone Flyer LLC · Avon, INN8494DKincaid Jonathan A · Frankfort, MEN8496YOsiol Russell E · Chicago, ILN8497PCrotts Leigh O · Peoria, AZN8498DBig Boy Business LLC · Oklahoma City, OKN8498PMiller Marc D Trustee · Tempe, AZN8499DHolton Randall B · Folley Beach, SCN849AScharf Mark T · Rosamond, CAN849ATAtp Taa LLC · Wilmington, DEN84JPNichols John E · Bogalusa, LAN84JSKocak Robert G Jr · Peoria, AZN84TDBailey Dennis · Kernersville, NCN84VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8500DScootair LLC · Alburgh, VTN8500QEilinger Richard L · Hertford, NCN8501DStrausser Brian J · Lower Burrell, PAN8501LSnider Scott E DBA · Turner, MTN8502DConrad Dylan · Randolph, WIN8503CScites Robert W · Toney, ALN8503YRoberti John O · Barre, VTN8504LTexas Soaring Association · Midlothian, TXN8505DRegistration Pending · Wilmington, DERegistration pendingN8505YCli Aerospace LLC · Appleton, WIN8506YWilliams Russell D · Rehoboth Beach, DEN8507DFischer Duane A · New Baden, ILN8507YWhiteley Robert L · Pittsburg, CAN8508DHuhndorf Joshua L · Port Ludlow, WAN8509DVeal Petra I · Sterling, AKN8509PWalsh Robert A · Katy, TX
Back to AD 85-02-05 R1