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.
N88243Newbegin James T · Mc Alpin, FLN88245Steinle Michael · Lake Village, INN8824CRodriguez Carlos S · Poughkeepsie, NYN8824ECornelius John A · Fort Worth, TXN8824JJohnson Lawrence F · Ancorage, AKN8824NDale Keith Wayne · Gurdon, ARN88252Schell Joseph H · Granbury, TXN88256Greensted Richard E · Anchorage, AKN88258Ohlman Terry · Franktown, CON8825AGauges Green LLC · Euless, TXN8825JAlexander Carol E · Pineville, LAN8825NMissouri River Flying Club LLC · Mandan, NDN8825ZDisrud Roger G · Olathe, KSN88264Summers Philip A · Fairbanks, AKN88265Reiner Buck · Fishtail, MTN88266Kraxberger Rick R · Kasilof, AKN88268Neidert Melvin E · Ulysses, KSN8826DSongster Kevin M · Friend, NEN8826NWg Aviation LLC · Shippenville, PAN88273Pettijohn Patton D · Wasilla, AKN88276Straten Oliver · Wasilla, AKN88277Reid Paul E · Firth, IDN88278Crosswell Joe D · Springtown, TXN88280Lazareanu Sorin D · Apex, NCN88281Auten James W · Stratford, CTN88287Meyerkorth Aviation LLC · Rock Port, MON88288Cain Philip K · Escondido, CAN8828FJohnson Martin L · Agua Dulce, CAN8828YConard Thomas M III · Huntsville, ALN88290Outer Banks Seaplanes LLC · Manteo, NCN88297Naber David Lowell · Fairbanks, AKN8829CJohnson Steven D · Pardeeville, WIN8829DSchwenninger Ronald L · Allison Park, PAN882ATDot Aviation LLC · Wilmington, DEN882BKRegistered aircraftN882FDrb Helicopters LLC · Klamath Falls, ORN882GHunt David Gregory Trustee · San Diego, CAN882KMMatheny Robin M · Titusville, FLN882MASmith David E · Green Valley, AZN882PDEdwards Charles Steve · Fowler, KSN882RVCrissinger William M · Carl Junction, MON882WPSouth Florida Oasis LLC · Weirsdale, FLN88303Airplanes LLC · Springfield, ORN88305Loprinze Aviation LLC · Nashua, NHN88306Shaw David H · Nenana, AKN88307University Of Alaska Anchorage Aviation Technology · Anchorage, AKN88309Larkin Edward C · Covington, KYN8830JAnderas Per R · Green Bay, WIN8830PCanon Daniel H · Fruit Cove, FLN88311Nelson Jayson L · Glasgow, MT
Back to AD 90-04-06 R1