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.
N6720AFremgen Stephen M · Carrollton, TXN6720ESegerstrom Ricky G · Grandview, TXN6720GMcclintick Marshall Wyatt · Daniel Island, SCN6720RJacobsen Ian M · Lincoln City, ORN6720SWilliams Kenneth J · Hampton, NYN6721ARogers Jeffery D · Franklin, WIN6721ESonoma Valley Aircraft Inc · Vineburg, CAN6721SRenwick Stephen P · Moss Beach, CAN6722BJca Aviation LLC · Safford, AZN6722GPiasa Flyers Inc · East Alton, ILN6722MLatham Scott W · Naples, FLN6722SCampbell J Tyler · Chestertown, MDN67236Cessna N67236 LLC · Harrah, OKN6723GPressley Brandon S · York, SCN6724AGodin George A · Franklin, VTN6724RDavis Lease LLC · Fort Collins, CON6725ESocal Jet Services Inc · Long Beach, CAN6725FReberry Brian Keith · Boise, IDN6725GJohnson Andrew E · Prior Lake, MNN6725SMarshall Jerry J · Parker, AZN6726FBlackford Robert G · Summit Point, WVN6727HAldora Enterprise LLC · League City, TXN6727RChase Holden · Boulder, CON6728ELincoln Gene T · Delta, CON6728SStevens Matthew S · Penn Yan, NYN6729AO Tuel Maxcy Bryant · Mooresville, NCN6729FLuke David E · Lubbock, TXN6729GBelgacem Yassine · Harrisburg, PAN6729RDfo Dynamic Aviation LLC · Glendale, AZN6729SCain Tyler M · Houston, TXN672CCDmac Aircraft LLC · Savannah, GAN672CPCivil Air Patrol · Maxwell Afb, ALN672DMWoodland Works Inc · Buena Vista, GAN672EBAviation Associates Of Hanover LLC · Enfield, NHN672EREmbry-Riddle Aeronautical University Inc · Prescott, AZN672FCBlackhawk Holding Corp · Wilmington, DEN672MALewis University · Romeoville, ILN672SPThomas Bahamas Airways LLC · Port Orange, FLN673Henniker Flying Club Inc · Concord, NHN6731ELyon Joseph K · Pocatello, IDN6731SHaug Jeffrey S Trustee · Leawood, KSN6732AHurst Construction Co · Denton, TXN6732FSmith Tyler C · Wasilla, AKN6732ROregonian Flying Club · Wilmington, DEN6733AJaed Gerald E · Yankeetown, FLN6733GAsaro Carlo · Waterbury, CTN6735AHinkle Robert J · Caldwell, IDN6735EPollock Patrick B · Temecula, CAN6735GRedeemed Flying Corps Association · Oklahoma City, OKN6735HWhitney Dudley P · Windsor, VT
Back to AD 79-10-14 R1