AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N6227FAlund Timothy · Watervliet, NYN6227KBuchman Jeffery · Bushnell, FLN6227RMidwestern Soaring Assoc · Peculiar, MON6227YWest Brook Group Inc · Pleasant Hill, IAN62281Christiansen Aviation LLC · Wilmington, DEN62283Flight School Of Gwinnett Inc · Lawrenceville, GAN62287Glidewell Aviation Inc · Parkland, FLN6228FLynch Kent · Edwards, ILN6228KSunset Leasing Inc · Sarasota, FLN6228NGreenwich Venture Partners LLC · Greenwich, CTN6228RMangham Charles H · Mineral Wells, TXN6228SYoder Edwin A Jr · Concord, GAN62296Sale Reported · Signal Hill, CASale reportedN62299Blanton Robin Anthony · Vero Beach, FLN6229ABrown Jennifer L · Vancouver, WAN6229CClause James W Trustee · La Quinta, CAN6229EBidus Brent E · Sandpoint, IDN6229FGav Air Capital LLC · Trophy Club, TXN6229QChristiansen Aviation LLC · Wilmington, DEN622APCaradine Jimmie · Commerce, TXFirst renewal noticeN622CMMcgill Charles · Sunriver, ORN622DCCarter Aviation LLC · Denver, CON622DLColorado Aircraft Corp · Watkins, CON622EHaggerty Russell P · Bethpage, NYN622EFEpic Aviation Inc · New Smyrna Beach, FLN622FEPeninsula Aero Technology Inc · Kenai, AKN622FHNational Aircraft Leasing Corp · Greenville, DEN622GPTwenty Two Ashford LLC · Brentwood, TNN622KCAir Burt LLC · Rochester Hills, MIN6230Cavanaugh Paul R · Plantsville, CTN6230DUsda Aphis Wildlife Services · Cedar City, UTN6230EDean Matthew · Pine Grove, CAN6230SMelnyk Oleg · Willoughby Hills, OHN6231EMiller Edward P · Northfield, MNN6231FH & F Aviation Inc · Labelle, FLN6231RSando Mark T · Carson City, NVN6232APeters Duane A · Anchorage, AKN6232DJav Air Services LLC · Anchorage, AKN6232RBeavers Benjamin K · Omaha, NEN6232TDavenport Richard B · Danbury, TXN62332Skylens LLC · Hammond, LAN6233AAgl Aero LLC · Mckinney, TXN6233DGrauert Ritter Trustee · Van Nuys, CAN6233FBach Haley Rayna · Sedona, AZN6233S33sierra LLC · Soldotna, AKN6233ZMission Aviation Fellowship · Nampa, IDN62348Hillsboro Aero Academy LLC · Hillsboro, ORN6234ALiu Weston B · Brookline, NHN6234RFly Big Sky LLC · Missoula, MTN6234SCorbin M Stuller · Yoder, IN
Back to AD 79-10-14 R1