AD 75-09-13
Registered aircraft · 4,787
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:75-09-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
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:75-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13') 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.
N4134SQualitair LLC Trustee · MichelstadtN4135TNehls Chevrolet Olds Cadillac · Marshall, TXN4137CN4137c Inc · Redwood City, CAN413BMLee Aviation LLC · Sheridan, ARN413KJHuber Jeffrey C · Sidney, OHN413VVGardner John · New Hudson, MIN413WWWilkinson Jason S · Eastvale, CAN4140GCaribbean Development Partnership Ltd · Wilmington, DEN4146APinpoint Investment Capital Inc · Healdsburg, CAN4148GKutrieb Wolfgang Michael · Chetek, WIN414ACBirman Pablo · Suamico, WIN414AFSano Aviation Corp · Lewes, DEN414AKValiair Lc Trustee · Casper, WYN414AMToucan Aviation LLC · Lafayette, LAN414ARFlight Med LLC · Cumming, GAN414ASRobertson Julianne · Los Osos, CAN414ATCreekmore Arnold · Somerset, KYN414AWAlycone Trust Corp Trustee · Wichita, KSN414BDBostater Charles Jr · Indn Hbr Bch, FLN414BGGreen Forest Aviation LLC · Edmond, OKN414BMBorden John · Raleigh, NCN414BSHunger Relief Ministries · Forney, TXN414BTCmo Blue Sky LLC · Tomball, TXN414BWSky West Aviation Inc Trustee · Albuquerque, NMN414CASurgeon LLC · Arcadia, LAN414CDRepinter (Delaware) Inc · Coral Gables, FLN414CELocaero Services Inc Trustee · Wilmington, DEN414CLL Squared Aviation LLC · Marine, ILN414CMMartin Livestock LLC · Ione, CAN414CNAllied Asset Management LLC · Oklahoma City, OKN414CRAga Aviation LLC · Woodruff, SCN414CTHollywood Aviation Investments LLC · Hollywood, SCN414CWCrosswind Media LLC · Terrell, TXN414DBNerwelah Holdings LLC · Martinez, GAN414DDModern Custom Design LLC · Melbourne Beach, FLN414DKOn Top Aviation LLC · North Las Vegas, NVN414DLRestivo Joseph Sal · Cape Coral, FLFirst renewal noticeN414DNN5454x LLC · Lafayette, LAN414DPPlane Crazy Aviation LLC · Hollywood, SCN414DSGable S Corp · West Linn, ORN414EESp Aviation Inc · Hayward, CAN414ELKillion James L · Lubbock, TXN414ESPork Chop Express Aviation LLC · Las Cruces, NMN414EZMrjl LLC · Wilmington, DEN414FAGardiner Scott · Apache Junction, AZN414FBMk414 LLC · Fredericksburg, TXN414FCTaff Logistics LLC · Gilmer, TXN414FGGrisham Charlie · Odessa, TXN414FTR Yokem Aviation LLC · Shreveport, LAN414GGenerations Flying Club LLC · Washington, MO
Back to AD 75-09-13