AD 90-04-06 R1
Registered aircraft · 68,359
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.
N100HUSimpson Jared S · Malad City, IDN100HWYale Companies LLC · Fishers, INN100JEResearch Consultant Solutions LLC · Miami, FLN100JMGregg Delvin K · Durango, CON100KCMiller Byron W · Silverton, ORN100KYRegistration Pending · Weston, FLRegistration pendingN100LDPenning Jeffrey D · Clear Lake, IAN100MSky Odyssey Aviation LLC · Gulf Breeze, FLN100MPMeyer Christopher R · Colchester, CTN100MSHam Aviation LLC · Marydel, DEN100MVBensen John A · Greenville, NYN100NTBk Aviation LLC · Reno, NVN100NYAplustill Keith A · Los Osos, CAN100PPExplore Helicopters LLC · Lexington, ALN100PTJacobs Brian E · Aptos, CAN100QRichmond Suzanne L · North Hills, CAN100RFN100rf Ghost LLC · Burleson, TXN100RKEllingson Leslie B · Harwood, NDN100RVMaule Group Ltd · Wilmington, DEN100SELanger Paul Hubert · Gainesville, TXN100SQBowles Chris · Taylorsville, NCN100SVKretschman Thomas J · Verona, WIN100SXKing Samuel E · Battle Mountain, NVN100TOwyhee Pacific LLC · Kalispell, MTN100TCMckinney Richard P · Fayeteville, ARN100THWhiddon Mark H · Frankston, TXN100TNMoore Glenn C · Elkhart Lake, WIN100UDVogel Kelly C · Ventura, CAN100UVJohn B Bateman · Draper, UTN100WHTowb Parmalee · Chula Vista, CAN100WLLively Wade C · Spring Branch, TXN100WRBuehler Andrew · Eatonville, WAN100WWSwearengin David · Lula, GAN100XXAskew Stell Blake III · Durham, NCN100YAShelton Joel T · Grass Valley, CAN100YVPalmy LLC · Lander, WYN1010MSimpson Kendal L · Port Orange, FLN1010QBurklund Joel H · Minneapolis, MNN1010RKaneair LLC · Hayes, VAN1010TReilly Patrick W · Rockford, ILN1010YGregory Kenneth · Crowley Lake, CAN1011AMachamer John K · Gettysburg, PAN1011JJames Robert L · East Setauket, NYN1011LColburn Paul A · Hillsboro, NHN1011NBlue Skies Aircraft LLC · Zephyrhills, FLN1011TPedersen Michael · Bakersfield, CAN1011ZChiappe Richard S · Estes Park, CON1012ASimmons Michael T · Carolina Beach, NCN1012GForwalt Lucas A · Chesapeake, VAN1012JOld School Aircraft LLC · Rogers, MN
Back to AD 90-04-06 R1