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.
N454WCNielsen Kai V · Arlington, WAN454WLLearn Build Fly Inc · Wausau, WIN454WWTate Larry J · Mountain Home, ARN454WYBrongworx LLC · Ballwin, MON454XThree Wing Flight School LLC · Stratford, CTN454ZRoswick Robert J · Bismarck, NDN45502Sims Hal Christopher · Colleyville, TXN4550DCharlymark 7 Flight Club LLC · Jamaica, NYN4550EPommy & Swede LLC · Valentine, NEN4550WNewton Property Leasing LLC · Greene, IAN4550XAltitude LLC · Madison, WIN4551FViser Timothy A · Cleveland, TNN4551HLehnert Roger J · Kennett Square, PAN4551XLewis Michael A · Alexandria, VAN45526Mvs Air LLC · Kalispell, MTN4552AHall Mark R · New Smyrna Beach, FLN4552HWatkins John J · Dalhart, TXN4552JAg Air Squadron One LLC · Saint Joseph, ILN4553UCoyle Jonathan D · Franktown, CON4553ZRisbon Scott W · Crystal Spring, PAN45543Colwell Mark C · ArrhusN4554BWoodrum Steven E · Fort Wayne, INN4554HGehrels Leslie D · Spirit Lake, IAN4554TGlazer Aviation LLC · Owings Mills, MDN4554XSchwartz Michael · Bethel, CTN45552Aerospace Trust Management LLC Trustee · Wilmington, DEN4555ALifetime Adventures LLC · Bellevue, MIN4555HHuntley Lawrence H · Hernando, FLN4555REagle Aeronautical Company LLC · Dover, DEN4555TJb Aviation LLC · Mason City, IAN4555WSan Diego Aerobatics LLC · San Diego, CAN4555ZScottini Ryan M · Kent, OHN4556AScott Brent A · Fulton, MON4556BStrotkamp Timothy B · Sugar Land, TXN4556HGlenn Danny M · Centerville, IAN4557ABuskey Walter B · Etna, NHN4557DWoodhead Harold Kenneth Jr Trustee · Tulsa, OKN4557LSkytypers Inc DBA · Las Vegas, NVN4557RThomson James A · Boron, CAN4557SJustus Gary R · Evergreen, CON4557TWomack Associates LLC · Lancaster, KYN4557YPogany Stone C · Anchorage, AKN4558ESmith Gregory W · Weirsdale, FLN4558HTjr Inc · Bellevue, NEN4558JDaprile Jonathan · Port Charlotte, FLN4558RMorgan Chad A · Sarepta, LAN4559AKsm Aviation LLC · Kalispell, MTN4559BSpencer Douglas L · Lexington, GAN4559HWestern Antique Aeroplane & Automobile Museum · Hood River, ORN4559JBolduc Michael A · Strong, ME
Back to AD 90-04-06 R1