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.
N54910Somboonsap Patanapong · Oakland Park, FLN5491BSmith Richard D II · Luthersville, GAN5491HSky Hogs LLC · Orange Park, FLN5491JChristiansen Aviation LLC · Wilmington, DEN5491KSale Reported · Rowland, NCSale reportedN5491NLacefield Tommie C · Niceville, FLN5491RSingh Jaspal · Sacramento, CAN5491TAlpha Mike LLC · Stoughton, MAN5492CSorensen Bjarne K · Vero Beach, FLN5492HAcme Aircraft Flying Club LLC · Kalispell, MTN5492QMarchant Colby Z · Hazlehurst, GAN5492TCollins Terry D · Maynardville, TNN5493AValley Dairy Farms Inc · Roy, WAN5493CHetchler Glenn A · Erie, CON5493NOcaid Equipment Leasing LLC · Spring Valley, NYN5493RFreedom Flight Center Inc · Hardy, NEN54946Goosfraba LLC · Huddleston, VAN54947Christiansen Aviation LLC · Wilmington, DEN5494EBloom William K · Wrangell, AKN54951Skylens LLC · Hammond, LAN54955Space 5 LLC · Fayetteville, GAN54956Fluke Dennis M · Sunset, TXN5495ARzs Enterprises Inc · Finley, NDN5495BCable Strong Aircraft Holdings LLC · Tyler, TXN5495CWallace Tracy C · Santa Rosa, CAN5495DSorbi Aviation Inc · El Cajon, CAN5495KI Fly High LLC · Mesa, AZN5495RLee Ernest J Jr · Danielson, CTN5495VPhillips Ruffin P Jr · Lexington, NCN54960First Eclipse Ltd · Richmond, VAN5496EFair John C · Rockport, TXN5496HWilson Charles L · Seattle, WAN5496QPhillips Michael · Bossier City, LAN5496RFitzgerald Douglas A · Stockton, CAN54973Szymanski Tadeusz C · Fort Myers, FLN5497BBlue Sky Powers N5497b LLC · Dover, DEN5497NBeelieve LLC · Carmel, INN54983Jin Jin Aviation LLC · Anchorage, AKN5498CKfg Aviation Inc · Huntersville, NCN5498HGulf Atlantic Airways Inc · Gainesville, FLN5498QAtlanta Technical College · Atlanta, GAN5498RWilson Dale L · Escalante, UTN5498TSale Reported · Lewes, DESale reportedN5499CJohnson Linzy A · Lake Stevens, WAN5499RHooper Gordon T · Hiawatha, KSN549ASouthern Illinois University · Murphysboro, ILN549BCMitchell Rosemary · Harbour IslandNon-citizen corporation, flight hours not reportedN549EREmbry-Riddle Aeronautical University Inc · Prescott, AZN549NDSpartan Education LLC · Tulsa, OKN549PUBerkey Aviation LLC · Lafayette, IN
Back to AD 79-10-14 R1