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.
N62873Sky Sailing Inc · Warner Springs, CAN6288PKeenan Douglas P · Boulder Creek, CAN6289PRegistered aircraftN-number assigned, not yet registeredN628AWHobart Aviation Inc · Akron, OHN6291ZBordelon Thomas D · Elephant Butte, NMN6292YHardesty George J · South Bend, INN6293PAndersen Ted · Alamosa, CON62969Ls Aviation LLC · Searcy, ARN6298PN6298p Inc · Okeechobee, FLN6299YT&T Aviation LLC · Clarksville, TNN629HBBattle Creek Powersports LLC · Jasper, TNN62ADHawkins Flight Academy LLC · Shelbyville, TNN62FRRossi A F · Belmont, CAN6301PDavid A Gowan · Templeton, CAN6302PBarber Stephen R · Gainesville, GAN6303PMarlette Ellen J · Cohasset, MAN6304ZVintage Aero Sports LLC · Easton, PAN6310PPopel John G Sr Trustee · Piqua, OHN6316PHitt Edward L · Statesboro, GAN6317PYounhorsh Sales LLC · Wilmington, DEN6318PBlaha Karl F · Ocala, FLN6319DBores Scott J · Huron, OHN6319PBedenbaugh Michael B · Lake City, FLN6319ZSouthern Cub & Aircraft Restoration LLC · Pensacola, FLN6321YHallstein Roy M · San Jose, CAN6324DSmart Charles R · Verden, OKN6327PSunspot Investment Corp · Marathon, FLN6329PKhan Adam Iqbal Ahmed · Sanger, TXN632ACarroll Dana C · Wirtz, VAN632BZRegistration Pending · Liberty, NCRegistration pendingN6334YHofer Perry L · Doland, SDN63398Norman Robert A · Zanesville, OHN633AMoeckly Steven L · Polk City, IAN633TAChristiansen Aviation LLC · Wilmington, DEN633WSGilmores Glorious Goods LLC · Lewes, DEN6343PMcgowan John B · Sunnyvale, CAN6344PStanford Scott M · Spring Branch, TXN6347PGear Down Hangar LLC · Phoenix, AZN6348PRoddy Shannon B · Walker, LAN6352PGassaway Mitchell E · Carrollton, TXN6353PMoore Byron · Elkhart, INN6353YAlpine Aviation LLC · Oasis, IDN6355YSky West Aviation Inc Trustee · Albuquerque, NMN6355ZQuality Aviation Inc · Marana, AZN6360PRoyal Scott A · Richmond, MEN6362PStearman Aviation Inc · Crawford, CON6364PAdamczyk Douglas · Surprise, AZN6367PFrancis Thomas R · Lamar, CON6368PRbr Aircraft Inc · Albuquerque, NMN6369PKeith Don Paul · Bakersfield, CA
Back to AD 85-02-05 R1