AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N45162Barrell Shelly R · Brownsburg, INN4516JFly By Nite Aviation LLC · Tampa, FLN4516NRegistration Pending · Carlsbad, CARegistration pendingN4516SConcepcion Carlos L · Pembroke Pines, FLN4516TAir Time LLC · Newport, RIN4516XMckown Martin H · Ocean City, MDN45175Hale Leland E · Warrington, PAN4517AShepherd Joseph Gary · Sharpsburg, GAN4517B4517b Holding Group LLC · Moses Lake, WAN4517NHosch Stephen R · Louisville, KYN4517QMarburger James H · Phoenix, AZN4517RGilbert Zachary · Jekyll Island, GAN4517TTate Levi W · Saint George, UTN4517YHoffmann Earl R Jr · Wildwood, MON45187Hill Samuel D · Dover, DEN4518AJensen Dustin C · Santa Clara, UTN4518BSmoke Seen LLC · Farmingdale, NYN4518ERegistered aircraftN4518JFaizanali Hashme I · Middletown, OHN4518KBrush Creek Farmhouse LLC · Valparaiso, INN4518QLloyd Patrick · Durham, NCN4518REdmondson William A · Rosamond, CAFirst renewal noticeN4518TBnr Aviation LLC · Lawrenceville, GAN45191Rinckel Jeannie M · Wilmington, NCN45199Decou Miller C · Chester Springs, PAN4519EPalocz Spencer F · Weston, MAN4519SBlanck Greg J · Redwood City, CAN451ATMaxflight Helicopter Services Inc · Kissimmee, FLN451BA1928 LLC · Salmon, IDN451BTNeosho Investments LLC · Neosho, MON451CDDull Kevin M · Northlake, TXN451CPCivil Air Patrol · Maxwell Afb, ALN451DDJth Holdings LLC · Flemingsburg, KYN451GRMidwest Kilo Delta LLC · Clara City, MNN451JSend North · Anchorage, AKN451KWKw Plastics · Troy, ALN451LLRobinson Helicopter Co · Torrance, CAN451LXBassen Gerald R · Saint George, UTN451MCAero-Tech Helicopters LLC · Kingstree, SCN451MKNorth Star Aviation Inc · Mankato, MNN451NACooke J C Jr · Crystal Springs, MSN451PSUpside Down Aero LLC · Aberdeen, IDN451STrevathan Max Tyler · Dyersburg, TNN451SABobbitt Cole T · Jasper, GAN451SBModleski Matthew · Noblesville, INN451SWAircraft & Aviation Professionals LLC · Coldwater, MIN451TJSr22 Aviators LLC · Crete, ILN451TWYale Companies LLC DBA · Indianapolis, INN451WSG&S Property Management LLC · Saint Ignatius, MTN451XCross Winds Flying Club Inc · Bloomington, IL
Back to AD 2007-04-19 R1