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.
N55VLDarian Alexander L · Brightwaters, NYN55VSSkie Flying Club LLC · Campbell, CAN55WAHudgens Terry L · Blockton, IAN55WBMetro Flyers Ltd · Wilmington, DEN55WCHagan Jeremy D · Madrid, NEN55WMBankston Jeffery · Rice, TXN55WRNeumann Capital Holdings LLC · Bossier City, LAN55WYCentury White Worldwide Inc · Casper, WYN55XFCeb Enterprises LLC · Petal, MSN55XLBusiness Development Systems LLC · Seaford, VAN55YBLockhart John E · Phoenix, AZN55ZZMaxson Lee V · Mesa, AZN56000Wings Over Texas Holdings LLC · Denton, TXN56001Citabria LLC · Missoula, MTN56002Clark William · Gig Harbor, WAN56007N56007 LLC · Burke, VAN56008F R G III Inc DBA · Lincoln Park, NJN5600BParks Darryl D Trustee · Eagle River, AKN5600CRegistered aircraftN5600JHigh Country Aircraft LLC · Westcliffe, CON5600KHurta Jennifer Nelsen · Cypress, TXN5600MClarke Michael J · Baker, FLN5600QA & D Aviation LLC · Aberdeen, OHN5600UCorey Marlin F · Choctaw, OKN5600WFitzgerald Anthony M · Crete, NEN5600YNelson Kenneth A · Fort Mill, SCN56015Ac Sales & Investments LLC · Hickory, NCN5601EMarshall Joseph · Uniontown, OHN5601GRetzlaff Cathy S · Oshkosh, WIN5601JGoos Lynn A · Silver City, IAN5601PDevil Dusters Inc · Artesia, NMN5601QRegistered aircraftN5601SArno Aero LLC · Merton, WIN5601WTaylor Larry J · San Manuel, AZN56023Bennett Paul · Phoenix, AZN5602JVarga Aircraft Co · Hephzibah, GAN5602QWacker Jeremy C · Denver, CON5602SRegistered aircraftN5602WSaunders Nathaniel E · Muskegon, MIN56031Musser John R · Freeport, ILN56032Umo Flight School LLC · Mount Olive, NCN56033Larson Douglas R · Goodyear, AZN5603JMiller Duane A · Redlands, CAN5603LKushnir Borys G · Tamuning, GUN5603PLitteken David T · Aviston, ILN5603WElliot Harold F II · Pomeroy, OHN56041Haddad Joe · Charlotte, NCN5604JJohnson David A · Sunrise Beach, TXN5604KX-Country Ventures LLC · Usafa, CON5604QSkywagons.Com LLC · Placerville, CA
Back to AD 2007-04-19 R1