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.
N6050FAmeriflyers Of Texas Inc · Addison, TXN6050LPerry David · Onancock, VAN6050WLandoll Aero LLC · O Fallon, ILN6051GHarvey William W · Spencer, INN6051LMiller Lyndon · Georgetown, TXN6051QWhite Jeffrey M · Carlsbad, CAN6051RSpalding David · Ketchum, IDN6052GErickson Keith E · Anchorage, AKN6052LHoward William R · Newnan, GAN6052NRegistration Pending · Las Vegas, NVRegistration pendingN6052QCash Alan B · Fort Worth, TXN6052ZJackson Paul D · Phoenix, AZN6053DRuddell Brian G · Spokane Valley, WAN6053FAmeriflyers Of Texas Inc · Addison, TXN6053LHenson Randolph C · Spring, TXFirst renewal noticeN6053NErickson Robert · Otis Orchards, WAN6053ZSlack Brenda · Norfolk, VAN6054LTriple-R-Biplane Inc · Andover, NJN6054NPees Philip G · Concord, NCN6054PMartinez Juan R · San Bruno, CAN6055CPlanes Of Fame Air Museum · Chino, CAN6055QGlenn Howard Anderson Jr · Wakefield, RIN6056PN6056p LLC · Sonoma, CAN6056WHerfel Kevin R · Middleton, IDN6057HAerospace Trust Management LLC Trustee · Wilmington, DEN6057QKennedy Kyle R · Berrien Springs, MIN6057WConroy Lance R · Norfolk, NEN6058DJohnson Aaron J · Lewiston, IDN6058FAmeriflyers Of Texas Inc · Addison, TXN6058LMccune William D · Tehachapi, CAN6058WJardine Michael K · Corona, CAN6058ZBlackstone Aircraft LLC · Hartselle, ALN6059HOverholtzer Mark S · Salem, ORN6059PShearer Jay E · Coshocton, OHN6059QSchoenleben Thomas J · Stevensville, MTN605ADBlue Sky Aviation LLC · Great Bend, KSN605CCPatterson Kyle M · Torrington, WYN605FTOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN605GCareer Pilot Training LLC · Wilmington, DEN605HAEmerald City Aircraft Leasing Inc · Port Orchard, WAN605JCHustler Aviation LLC · Huntsville, TXN605JTKiefer Matthew J · Xenia, OHN605LYLofstrom Caleb J · Wasilla, AKN605MAAir Assets LLC · Orlando, FLN605MNSale Reported · Boise, IDSale reported, pending cancellationN605PFBaez Asael · Shillington, PAN605RSMegerdoomian Eric · Fort Riley, KSN605RVMalocsay Michael M · Golden, CON605TCOhtonen Thomas R · Chassell, MIN605WCGyger Keith J · Granbury, TX
Back to AD 90-04-06 R1