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.
N9163ZPray Aviation Inc · Augusta, KSN9164JArizona Airbourne LLC · Gilbert, AZN9164SGreat Planes Flyers LLC · Mccook, NEN9164VMccurry Larry A · Double Oak, TXN9165DNelson Vanessa Jump Trustee · Portland, ORN9165KCasey Matthey J · Sedalia, CON9165SHufford Christopher · Tucson, AZN9165VJohnson Michael · Huntington Beach, CAN9166JRed Rock Flying School LLC · Mesa, AZN9166LSutton Aircraft Salvage LLC · Palmer, AKN9166SHarris Douglas H · Morgan, UTN9166TBoling Scott D · Idaho Falls, IDN9166VSiddiqui Shariq M · Poinciana, FLN91673Martin Charles W · Twain Harte, CAN9167SContinental Aviation Club Inc · Lincoln, VAN9167VChapman William Herbert · Dayton, OHN9168J2binc LLC · Adrian, MIN9168LMoore Jon · Chuckey, TNN9168QPhillipson Justin M · Vacaville, CAN9168VSnow James W · Avon, INN9169DLapaseotes George P II · Sidney, NEN9169LSimons Grant C · White Owl, SDN9169NWestern Sky Aviation Warbird Museum Inc · St George, UTN9169RDye Rodney D · Marietta, OHN9169THayes George F · Friendsville, PAN916ALea Martin T · Mesa, AZN916ARRowe Stanley P · Pierson, FLN916ATKdrd Holdings LLC · Texas City, TXN916AVLopez Virgilio D · Brookshire, TXN916BNAir Care Leasing LLC · Lamar, CON916CLDolphin Sales Inc · Wilkes Barre, PAN916DBJj & Sons Aviation Services LLC · Tampa, FLN916DROliver Randy M · Limerick, MEN916HPNeustaeter Pedro Thiessen · Anthony, NMN916JFHammett Gary N · Prince Frederick, MDN916JGGriffin Aerospace Solutions LLC · Bridgeport, WVN916JTRugg Ranches LLC · Pilot Rock, ORN916KSmith Brandon D · Laguna Beach, CAN916MABusch Brett · Stanford, MTN916MHHelmerich Jonathan D Jr · Tulsa, OKN916MRReyes Michael L · Kansas City, MON916PYBragg Kris M · Embden, MEN916RDUssery Donald R · Blytheville, ARN916SEEiland James · Phenix City, ALN916STHorizon Aviation LLC · Kalispell, MTN916TBShearer Gregory L · Avon, INN916TMMo Properties & Investments LLC · Lakewood, CON916TTReyes-Hernandez Jose R · San Juan, PRN916YEggimann William W Trustee · Anchorage, AKN9170DSmith Glen R · Tracy, MN
Back to AD 90-04-06 R1