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.
N5129QWaters John E · Renton, WAN5129SSplendid Aviation Inc · Corpus Christi, TXN5129VBirdzell Luther E · Hood River, ORN5129WStanek Kenneth W Jr · Russellville, ARN5129XSmall Aviation No 2 LLC · Villa Rica, GAN5129YCarter Ronald Lynn · Nenana, AKN512ABurns Daryl R · Walker, IAN512ACBuck James Kyle III · Oak Ridge, NCN512AFAmeriflyers Of Texas Inc · Addison, TXN512BLawler Glenn M · Mooresville, NCN512BWMontauk Catamaran Co LLC · Montauk, NYN512FLReiley Allen Ted · Lavernia, TXN512JHHenson David · Fallon, NVN512KCJunfer Flyers LLC · Wilmington, DEN512MACurrie George H III · Fleming Island, FLN512MSTiralongo Sebastiano · Weston, FLN512PTHigh Performance Aircraft LLC · El Cajon, CAN512PVWalker John A · Kotzebue, AKN512RSRollison Michael W · Fairfield, PAN512SInternational Air Services Inc Trustee · Carson City, NVN512SPAvolant Aviation LLC · Mooresville, NCN512TFN408dm LLC · Rye, NYN512TMSouthern Flight Aviation LLC · Bainbridge, GAN512WMcm Sports LLC · Hailey, IDN51300Loftin Gabe · Weatherford, TXN5130EAviation Capital Management LLC · San Jose, CAN5130HCalkins David Martin · Anchorage, AKN5130LSalisbury Gershom · Prescott, AZN5130PWhite Guy B · Waxahachie, TXN5130RShamp Jimmy L · Fresno, CAN5130TInfinity Aviation LLC · Piedmont, SDN5130WMccutcheon Ernest Thomas · Ninety Six, SCN5131Registered aircraftN5131EBrunken Barry D · Tower Hill, ILN5131LSkipper Up LLC · Herron, MIN5131RMlt Operations LLC · Traverse City, MIN5131SForan Dana Francis · Bement, ILN5131VBuswell Aviation Inc · Salem, ORN5131WArias Timothy R · Tempe, AZN5131XWilson Brent S Trustee · Dyer, NVN5132HMohnacs Joseph T · Mount Laurel, NJN5132LMongare Job · Athens, TXN5132NCoulter Ronald F · Brownsville, ORN5132PMccormick Geoffrey D · Goodyear, AZN5132QHauptman Ben · Alexandria, VAN5132SFightin Fourth Line Pilots LLC · Gig Harbor, WAN5132ULiberty Exploration Inc · Las Vegas, NVN5132VFord Lynn W · Gibsonia, PAN5132WSmith Dale S · Grass Valley, CAN5132XLinch Travis R · Belle Fourche, SD
Back to AD 90-04-06 R1