AD 75-08-03
Registered aircraft · 10,858
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-08-03')
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-08-03')
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-08-03') 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-08-03') 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.
N13KRKaplan Ronald · Palm Beach Gardens, FLN13MPPowell & Powell LLC · Northport, ALN14033Nomadic Flight Training LLC · New Castle, DEN1405XRij Edward · Clovis, CAN14060Skinner Daniel R · Mount Airy, GAN1406TCitabria Inc · Auburn, CAN1407XRavotti Air LLC · Leechburg, PAN1408TCarter Jeff · Paragould, ARN1409TAnker Mark W · Cambridge, OHN140ACApplebaugh Jeffrey · Mechanicsville, MDN140AMSuchko Paul S · Venetia, PAN140BCN504fl LLC · Killeen, TXN140BKFrauenhoffer Kenneth E · Woodruff, WIN140CKRegistered aircraftFirst renewal noticeN140DDBe Right Back Aviation LLC · Billings, MTN140FLYocum Stuart J · Kingman, AZN140GBReel Christen · Leighton, ALN140HACarros Dale A · Cape Charles, VAN140HCMurphy David B · Germantown, MDN140JFMeriden Aviation Center LLC · Meriden, CTN140JNMfd Aviation Inc · Middletown, DEN140KW47 North Aviation LLC DBA · Wenatchee, WAN140LRutten Paul J · Pine Island, MNN140MDDesotel Mark · Fairfax, IAN140NCRamirez Jesus Nicolas · Miami, FLN140PLBennett Daniel C · Atlantic Beach, FLN140SBSkyfusion II LLC · Atlanta, GAN140SDG5 Services LLC · Myrtle Beach, SCN140SHThomas Raymond · Daytona Beach, FLN140SNRomey Shelley · Newnan, GAN140WMBlue Wings LLC · Rossville, TNN140ZGitomirski Michael L · Moseley, VAN1410TWelch Bruce E · Boyce, VAN1411TCable Marsha A · Toronto, OHN1416TRegistered aircraftN1417TWood Andrew Calvin · Tallahassee, FLN1418TZucchi Steven · Ephrata, PAN1418XHaskin Kent B · Claverack, NYN1419TBrolan Aviation LLC · Kansas City, MON141KRScanlon John (Jack) · Palos Heights, ILN141SWCouture Logan · Grand Forks, NDN141TAPray Aviation Inc · Augusta, KSN1422XDt'S Aviation LLC · Garden City, KSN1423TWaggoner Kevin M · Donnellson, IAN1423XFigueroa Rafael A Jr · Coulterville, CAN1424TFoster Adam J · Houston, TXN1424XLewis Keith W · Clearwater, FLN1425TSkydance Aviation LLC · Norfolk, VAN1425XHowell Joshua · El Cajon, CAN1426XBair Preston W Jr · Coshocton, OH
Back to AD 75-08-03