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.
N70TPhillips Fire Design LLC · Colorado Springs, CON70TASixty Three Charlie Zulu Inc · Thonotosassa, FLN70WSKappel Fred G · Memphis, TNFirst renewal noticeN70WTLoboschefsky Terry · Park City, UTN70XPHolbrook Dennis · Woodbridge, CAN7100Registered aircraftN7100EStrickler Elizabeth D · Ringgold, TXN7100FRegistered aircraftN7100GBoyd John J · Wasilla, AKN7100UTeerlink Randall Spencer · Hanover, VAN7100WKlein Jarmes Harold · Lino Lakes, MNN7101GBowhawk LLC · Ocala, FLN7101UJucha Raymond A · Mount Dora, FLN7101VEquus All American LLC · Midwest City, OKN7101WDobson Michael E · Columbus, OHN7101YN7101y LLC · Wilmington, DEN7102GBarbosa Manuel · Apple Valley, MNN7102LWestergard Matthew J · Fort Mill, SCN7102PTurner Lake Aviation LLC · Sioux Falls, SDN7102QJuckett Jimmy L · Springhill, LAN7102WHower Nicholas J · Centerville, OHN71039Stan Lucian M · Sacramento, CAN7103GMountain Flyers Inc · Hendersonville, NCN7103VLennartson Gerald J · Greensboro, NCN7103WDunavin Joseph E · Menasha, WIN7104FPotrafka Richard M · Rolla, MON7104GAir Carriage LLC · Chico, CAN7104VPorzillo Patrick H · Newburg, MDN7104WRegistration Pending · Shelbyville, TNRegistration pendingN7105LTolbert John M · Jacksonville Beach, FLN7105UMolter Roy G · Shelbyville, INN7105VCromwell James T · Hamilton, MTN7105WDeibert Dale A · Herreid, SDN7106BSlaughter D Wayne · Farmsville, NCN7106DHarris & Associates Inc · Scottsdale, AZN7106KClark Patrick C · Charlotte, NCN7106UTappon Wayne A · Ladysmith, WIN7106VMcatee Von · Houston, TXN7106WGriffin Jim T · Tunnel Hill, GAN7107LYellowjet Flying Club LLC · Mukilteo, WAN7107UJohnson Kenneth D · Camdenton, MON7107WCaufield Dennis R · Carl Junction, MON7108DWestern Antique Aeroplane & Automobile Museum · Hood River, ORN7108GLakes Area Aviation LLC · Little Falls, MNN7108LWeiland Scott J · Howe, INN7108QAnderson Michael · Hillsboro, NDN7108RChristian Mark A · South Point, OHN7108WRed Rock Flying School LLC · Mesa, AZN7109BEastin Toby M · Jefferson City, MON7109KSheffield Vana Riggs Executrix · Amarillo, TX
Back to AD 90-04-06 R1