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.
N5175SBlu Skye Distribution Inc · Mount Holly, NCN5175TMcclain Timothy J · Tucson, AZN51768Stocker Concrete Co · Gnadenhutten, OHN51769Arizona Skies Aviation LLC · Scottsdale, AZN5176HBoyer Christopher A · Anchorage, AKN5176LMilliner Greg A · Kokomo, INN5176NWhittock Tyson H · Anchorage, AKN5176RRight Rudder Flight Training LLC · La Verne, CAN5176SNora Jet LLC · Granbury, TXN5176TScott Judson M · Wasilla, AKN5176VVangorder Donna · Greenwood, ARN51770Lrh Equipment LLC · Pendleton, ORN51776Pennewell Ollie Lee · Hannibal, MON51778Medical Evacuation Disaster Intervention Corps · Springdale, ARN5177FPray Aviation Inc · Augusta, KSN5177HPomeroy Cattle Ranch LLC · Kalispell, MTN5177PLi Steven Y · Warren, NJN5177TJensen Larry F · Millington, MIN5177WBuffham Daniel L · Meridian, IDN5177XAdams John L · Carmi, ILN51787Holder Michael T · Whitesburg, GAN51788Rhoads Timothy C · Logan, NMN51789Breyer Charles A · Lewes, DEN5178AHale Mitchell D · Chugiak, AKN5178HGage Scott M · Anchorage, AKN5178LMinick And Son LLC · Beatrice, NEN5178RHampton Flying Services LLC · Portsmouth, NHN5178WMahoney Christopher P · Quakertown, PAN5178ZUnderwood Robert D Jr · Randolph, NYN5179Bishop Kurt D · Findlay, OHN51790Tartock Russell L · Salisbury, NCN51793Lindsey Richard A · Richmond, TXN5179HFlight Time Builders Inc · Memphis, TNN5179PHangar 17 LLC · Sheridan, WYN5179THiggs Kathleen A · Garden Plain, KSN5179VFairmont State University · Fairmont, WVN5179XKor Reese W · Piedmont, SDN517APa28 Aircraft LLC · Wilmington, DEN517AFAmeriflyers Of Texas Inc · Addison, TXN517BWWomer Blaine A · Hemet, CAN517DLDelta Leema Aviation LLC · Moncks Corner, SCN517GSPtag Flight Service LLC · Vidalia, GAN517HWVogt Chancey · Becida, MNN517JGollus Daniel T · Lockport, NYN517JCProfessional Pilot Services · Appleton, WIN517JPJones Jerry K · Syracuse, UTN517LBuchenroth Steven L · Huntsville, OHFirst renewal noticeN517RLAndrews Mimi M · Hilltop Lakes, TXN517RSGraham Konner T · Pittsburg, TXN517SCSpartan Education LLC · Tulsa, OK
Back to AD 90-04-06 R1