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.
N5216ULeopard Air LLC · Oklahoma City, OKN5216VDeener Larry C · Lexington, KYN52170Blackerby Alexander N · Eola, TXN52172Troftgruben Gregory G · Buxton, NDN52175Sale Reported · Bangor, MESale reported, pending cancellationN52177Lundahl Frederick · Langley, WAN5217CHydro Wings Inc · Valle Crucis, NCN5217DOptima Aviation LLC DBA · Lewisville, TXN5217ERamsey Thomas R · West Bath, MEN5217HB&R Aircraft LLC · Wadsworth, OHN5217QGoode Stephen C · Canton, TXN5217UKelly Colby R · Anchorage, AKN5217VScrobola Air LLC · Wyoming, PAN52187Monk Robert William · Lake Tomahawk, WIN52188De Aviation Inc · La Porte, TXN5218ETopsail Beach Aviation LLC · Topsail Beach, NCN5218FMacmillan Performance LLC · Torrance, CAN5218GMarlowe James D · Genoa, OHN5218NMorin Shawn D · Franklin, TNN5218QRoberson J R · Mabank, TXN5218UWnc Aviation LLC · Arden, NCN5218YMcintire Aviation LLC · Middletown, DEN52190Vass Gal Alex D · Merrimack, NHN52195Cabane Marcelo J · Miami, FLN52197Hodges Ray L · Wasilla, AKN52199Registered aircraftN5219JUpham David E · Madison, WIN5219NA Cloud Above Aviation LLC · Spooner, WIN5219QVital Aviation LLC · Monterey, CAN5219RCoston Mace C · Maryville, MON5219URuryk Jonathan D · Pineville, LAFirst renewal noticeN5219VSkymates Inc · Wilmington, DEN521AFChhh LLC · Raleigh, NCN521BSAtlas Aviation LLC · Marietta, GAN521BWBilmar Avionics Inc · Kissimmee, FLN521CAAftcloud Inc · Ontario, CAN521DBBowling Donald W · Greensburg, INN521DJCuff Ronald J Trustee · Paso Robles, CAN521DMAllison James R · Middlefield, OHN521EPEpic Aviation Inc · New Smyrna Beach, FLN521ER521er LLC · Blaine, MNN521GTNeptune Skies LLC · Little Elm, TXN521JDH&G Farms Inc · Corcoran, CAN521JPJpm Flying Service LLC · Marine, ILN521JTDeralex Airways LLC · Miami, FLN521KMMcmorries Kyle P · Nacogdoches, TXN521KSKs Flying Club Inc · Manhattan, KSN521LDStar Marianas Air Inc · Tinian, MPN521MCBarr Air Patrol LLC · Mesquite, TXN521NDPhoenix East Aviation LLC · Daytona Beach, FL
Back to AD 79-10-14 R1