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.
N72342Ampaire Inc · Long Beach, CAN72347Hone Landscape Company LLC · Carnation, WAN7234AMoore Thomas K · Pleasant View, UTN7234GBittenbender Peter E · Grand Rapids, MNFirst renewal noticeN7234QLavinio Stephen E · Southampton, NYN7235GMcnair William H · Gold Beach, ORN7235XSpencer Tanya H · Coolidge, AZN72361Innovative Solutions Inc · Edmond, OKN7236MWright Steven William · Bend, ORFirst renewal noticeN7236QTeren Nelson F · Friday Harbor, WAN7236SJanvrin Jerry M · Buffalo, SDN72370Vinland Aerodrome Inc · Baldwin City, KSN7237GIvoprop Corp · Long Beach, CAN7237QMartin Bach Aviation LLC · Cornelius, NCN7237SMetcalf Rodney K · Jonesborough, TNN7238EStevenson Bill · Sunrise Beach, TXN7238MHubler Bruce F · Caldwell, IDN7238NKietzer Rocklyn D · Hartford, MIN7238SExecutive Flight Institute LLC · Murrieta, CAN72395Orion Works Ltd · Denali Park, AKN7239AEasley Daniel W · Wasilla, AKN7239EEnsey Gary D · Finley, OKN7239MPierce Steven P · Towanda, KSN7239NSea Island Skies LLC · Ponte Vedra Beach, FLN723CATextron Aviation Inc · Wichita, KSN723CSFinch Dennis G Jr · Long Prairie, MNN723DMCaswell & Sons LLC · Belmont, NCN723FClear Skies LLC · Stuart, FLN723GPuerta Jose Fernando Del Valle · Miami, FLN723HGFlight Operations Aircraft LLC · Wilmington, DEN723LAGregg James H · Parkton, NCN723LCLudwig Robert P · Pflugerville, TXN723LULiberty University Inc · Lynchburg, VAN723MDTextron Aviation Inc · Wichita, KSN723NETaft Millens W III Trustee · Wilton, CTN723PGPoplar Grove Airmotive Inc · Poplar Grove, ILN723SBFreeman-Benson Bjorn N · Portland, ORN723SEFrost Cavin Bert · Odessa, TXN723SPElite Approach LLC · Chesterfield, MON723SSTomlinson Jason R · Lake Jackson, TXN72403Drury Edward D · Little Silver, NJN72406Mercer Don G · Hendersonville, TNN7240AIrwin Timothy L · Cottonwood, AZN7240GKendallville Flying Club Inc · Auburn, INN7240XGootee Gregory A · Anchorage, AKN72412Intricate Bay Operating LLC · Saylorsburg, PAN7241AGibbs Geoffrey M · Holland, TXN7241MLabarre Ben A · Hayward, WIN7241SWatrous David S Trustee · Gainesville, VAN7241TSelleck Philip A · Falls Church, VA
Back to AD 79-10-14 R1