AD 73-07-07
Registered aircraft · 1,108
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:73-07-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-07-07')
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:73-07-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-07-07') 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.
N121BKSeabee Training Corp · Birmingham, ALN122SBCessna Twin Flyers LLC · Calhoun, TNN123DEGearhart John D · Arlington, WAN124DPBaja Air LLC · Wilmington, DEN125DMCallegari Gino A · Susanville, CAN126TMFlynfish Air LLC · Rome, GAN1274GSol Aerial Surveys LLC · Las Vegas, NVN127MBBerger Max · Daytona Beach, FLN1280GSky Aviation And Consulting · Panorama City, CAN1296GAir Dogs LLC · Watford City, NDN1297GPilot Mountain Aviation LLC · Marietta, OHN129ASPyxis Air LLC · Wilmington, DEN129DPSplendid Air Leasing LLC · Corpus Christi, TXN12TTThoms Robert D · Clyde, MIN12VLCrow Edward N Jr · Silverdale, WAN1313RAztexas LLC · Valley Farms, AZN131PBTom Tatum Pa · Danville, ARN1321GInnovative Poultry Products LLC · Olar, SCN1338GWings Air Charter LLC · Wisconsin Rapids, WIN1339GLyon Aviation Inc · Pittsfield, MAN133CWDeniro Corp · Hampton, NHN1342GSpector Steven D · Glenview, ILN1346GClear Blue Aviation LLC · Melbourne, FLN1349GWings Of Grace Ministries Inc · Melbourne, FLN1351G310 LLC · Conover, NCN1359GEaglehead Aviation LLC · Tifton, GAN1361QLannigan Anthony Robert · Tucson, AZN137Bigfoot Aviation LLC · Saint Michael, MNN1371GFall Gregory F · Hanson, MAN137DMiller Aviation LLC DBA · Huntington, INN13BPN13bp LLC · Walla Walla, WAN13PKOaks Aviation LLC · Clear Lake, MNN142CTMiddleton Charles H · Hamilton, INFirst renewal noticeN143MGPatriot Air Inc · Maryland Heights, MON143SWBb&D Airways LLC · N Redngtn Bch, FLN1491Petecraft Aviation Services Inc · Plains, GAN14BRGobin Albert W · Crawfordsville, INN14MCBlue Skies Blue Water LLC · Henderson, NVN150BGMbw Aviation LLC · Bay City, MIN1565TForbes Consolidated Inc · New Smyrna Beach, FLN157CCWhite David W · South Fulton, TNN1581GKovach Kenneth R · Jefferson, OHN15DSAll Attitude Aviation Inc · Edgewater, FLN15TVDfl Management Corp · New Castle, DEN15WRAcmc Operations LLC · Cedar Park, TXN165MHFortune Kyle D · Hampstead, NCN166AMColvin Clu D DBA · Big Cabin, OKN168EDTsg Aviation LLC · Wyandotte, MIN169DKStanton James · North Barrington, ILN1710HQuon Nicholas · Fayetteville, GA
Back to AD 73-07-07