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.
N450VVCarver Aero LLC · Muscatine, IAN450WMArbuthnot Michael D · Pagosa Springs, CON450WSMatter Donald Chad Trustee · Friendswood, TXN450YRSmith John W Jr · Stamps, ARN450ZRCasey William · Celina, TXN4510AGarvey James R · Fairhope, PAN4510DCamwhit Air Corp · Montgomery, NYN4510RMcmichael Steven G · Eden, NCN4510TNorthstar Holdings LLC · Anchorage, AKN4510YFrost John David Trustee · Anchorage, AKN45110Bluebeck Ltd · East Norwich, NYN4511BGcbc LLC · Norman, OKN4511EN2893e LLC · Reno, NVN4511HVeritas Urbis Economics LLC · Groveland, CAN4511JNoyes Tony · Lewisville, TXN4511VOraz Aviation LLC · Oregon City, ORN4511YWab Air LLC · Boulder, MTN4512LA&J Aircraft Leasing Inc · Burlington, CON4512RElder Abuse Air Force · Rcho Sta Marg, CAN4512XSullivan Bradley · Tomball, TXN4512YNohrenberg Redge O · Pingree, NDN45134Last Chance Lance Auto Sales LLC · Ardmore, OKN45135Warren Jeremy D · Bloomington, INN4513BBishop Robert W · Celina, TXN4513DRkm Aviation LLC · Lexington, NCN4513FDeripaska Gary Stanley · Owasso, OKN4513JMalone Ronald · Englewood, TNN4513MLeopold Aero LLC · Wilmington, DEN4513NRspp Group LLC · Friendswood, TXN4513RRegistration Pending · Fort Worth, TXRegistration pendingN4513YAlbertson James M · Slocomb, ALN45141T45141 LLC · Orange, CAN4514AJones N Robert II · Indianapolis, INN4514BNiemann Professionals P A · Melbourne Beach, FLN4514FBy The Grace Of God LLC · Miami, FLN4514JTrinity Aviation Ltd · Wilmington, DEFirst renewal noticeN4514MSpencer Joseph C · Evans, GAN4514NAbc Flying Club Inc · West Mifflin, PAN4514VTorelli Bruce L · Memphis, TNN4515BWestern Parachute Sales Inc · Eagle Creek, ORN4515DTucker Gary · Youngsville, LAN4515LBegich Michael James · Brea, CAN4515MCooper Steve O · Phoenix, AZN4515NAbsarokee Investment LLC · Billings, MTN4515PFlying W Leasing Inc · Bartlett, ILN4515SHarris Aviation LLC · Texarkana, TXN4515TSkyborne Airline Academy Inc · Vero Beach, FLN4515UHendrix William A · Flagstaff, AZN4515YArthur Aviation LLC · Arthur, NDN45161Tonry Roger D · Los Angeles, CA
Back to AD 2007-04-19 R1