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.
N31JKEquine Associates Inc · Bossier City, LAN31JLGines Roberto · Hypoluxo, FLN31JPOstmeyer John M · Gardner, KSN31JSChiles James W · Granbury, TXN31JWMiller Scott A · Granbury, TXN31KDChinook Fibre LLC · Wilmington, DEN31KEWilcox John B · South Charleston, WVN31KFSnow Terry R · Oak Harbor, WAN31KGMidwest Corporate Air Inc · Bellefontaine, OHN31KMMeine William F · Denver, CON31LDGustte Phil · North Fort Myers, FLN31LHUp And Up Aviation LLC · Magnolia, TXN31LLNeidert Melvin E · Ulysses, KSN31MAlley Shane C · Jackson, MON31MDKarmy Paul Edward · Burleson, TXN31MJN31mj LLC · Naples, FLN31MRAllred Don J · Wellington, TXN31MSWagon Leasing LLC · Jonesboro, ARN31NDSchloesser Raymond E · Poland, INN31PAUtter Joseph Lynn · Springfield, MON31PCFlight World Inc · San Juan, PRN31PEPhantom Eagle LLC · Hot Springs, VAFirst renewal noticeN31PGPlacette Jim · Houston, TXN31PLGorum Michael Wren · Red Lodge, MTN31PPPlyler Aviation Lp · Sherman, TXN31RKf Lift LLC · Snyder, TXN31RBTigre Ecossais Aviation Inc Trustee · Wilmington, DEN31REManley Brian C · Glen Allen, VAN31RTPapuchin LLC · Highwood, ILN31RWSpot Air LLC · Burlington, TXN31SN31s LLC · Wadsworth, OHN31SCObryant Jeffrey A · Fairbanks, AKN31SETangent LLC · Phoenix, AZN31SGHamilton Enterprises Inc · Reno, NVN31SMWings Over Texas Aviation Inc · Killeen, TXN31SRIsaac Timothy S · Independence, ORN31TAFulltron Aviation LLC · Springfield, MON31TBRusso Christopher · Huntsville, TXN31TDLewis Timothy H · Bristow, VAN31TGNaiman Nicholas A · Ramona, CAN31THNet Air Co · Monroe, MIN31TJAdams Ian B · Laramie, WYN31TLT M L Aircraft Inc · Narrowsburg, NYN31TVCornea Kevin Troy · Palm City, FLN31UPGuardian Aero LLC · Flora, ILN31VCVelocity Cruisers LLC · Mabank, TXN31VGTita Enterprises LLC · Apex, NCN31VHAmy Inc · Wilmington, DEN31VSJenny Timothy J · Remsen, NYN31VTSnediker Daniel G · Pittsburgh, PA
Back to AD 2007-04-19 R1