AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N538LJessup Ervin L · Cape Girardeau, MOFirst renewal noticeN538MRArinder Jeffrey A · Peachtree City, GAN538PGSundstrom Steven L · Friendswood, TXN538SCSpartan Education LLC · Tulsa, OKN538SPRc Flying Partners LLC · Fair Oaks, CAN53900Nielsen Jeffrey A · Frankfort, MIN53901Aero Flight Dynamics LLC · Riverside, CAN53903Campbell Kasey W · Thornburg, VAN53904Sundblad Ryan M · Albert City, IAN53905Registered aircraftN53906Mock George M · Jackson, GAN53907Sakalaskas Jason · Fairbanks, AKN53909Rawlings Cecile Cole · Palatine, ILN5390HRidgway Rick J · Carlisle, INN5390LKnight Ronald J · Mesa, AZN5390PHankins Jon A · Fort Mohave, AZN5390VSpringfield Flying Service LLC · Columbia, CAN53912Rider R.P. Field · New Gloucester, MEN53914Kauzlarich Steve F · Oakland, CAN53918N53918 LLC · Charles City, IAN53919Alexander Aviation LLC · Brighton, CON5391HHansen Alvin Kent · Winamac, INN5391LMarchant Kenneth L · Indianola, OKN53920Aero Dragger Ltd · Warminster, PAN53922Medford Pat G · Phoenix, AZN53923Little Dale E · Marshville, NCN5392HDeno Douglas · Battle Creek, MIN5392LYablon Brian M · Portland, ORN5392SBrickhouse Charles F · Wake Forest, NCN5392WCorbin Thomas D · Higley, AZN5392YJensen Jeff · Eagle River, AKN5392ZSteed Brian · Winnsboro, SCN5393HMacpherson Roni J · Cardiff By The Sea, CAN5393SSimpson Randall G · Norwalk, IAN5393WGrit Enterprises Inc · Tulsa, OKN53945Lewis Robert · Chandler, AZN5394BRichmor Aviation Inc · Hudson, NYN5394FLo Chris · Mesa, AZN5394WRosanova Richard · Flagstaff, AZN53952Oancea Traian · Oakdale, CAN53954Markey Jim F · Pocahontas, ILN53955Windsor Brian · Colfax, WAN53959Tailwheel Adventures LLC · Orlando, FLN5395FRegistration Pending · Granbury, TXRegistration pendingN5395HHansen James R · Kenmore, WAN5395LPfadenhauer James R · Burlington, IAN53960Iflytail LLC · Granbury, TXN53962Hatbright Farm LLC · Wilmington, DEN53965Robbennolt Steve L · Gettysburg, SDN53966Harris Kenneth L · Greeley, CO
Back to AD 90-04-06 R1