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.
N394TAikens George · Greeley, CON394WDDuffy William J · Hamilton, OHN394WTMorgan Edmund Neal · San Diego, CAN394XBenham Aaron J · Sullivan, INN39500Steen Farms LLC · Newhebron, MSN39501Jw & Jl Aviation LLC · Phoenix, AZN39503Demmery Daniel D · Port Saint Lucie, FLN3950MScifly LLC · San Diego, CAN3950QDieter Jason W · Midlothian, VAN3950TPark 46 LLC · Savannah, GAN3950WQctr Parts LLC · Big Rapids, MIN3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCN39512Tcb Consulting LLC · Yorba Linda, CAN39513Vitale F Richard · Colts Neck, NJN39517Dernoshek Logan · Kannapolis, NCN3951PDuncan Kyle A · Whiteville, NCN3951QGarcia Larry M · Garden Valley, CAN3951TScott Stanley L · Milton, FLN3951WRiebecing Karl F · Whitefish, MTN3951YRodriguez Coppola Patricio Andres · New Orleans, LAN3952ARegistered aircraftN3952FOdonnell David B · Milton, WIN3952KKnight Brett · Franklin, IDN3952MWhite Donald Ray Jr · Denton, TXN3952QLloyds 172 LLC · Moore, OKN3952RLovell Mark S · Templeton, CAN3952TSmith William J · Seaford, VAN3952VParker Venable · Malad City, IDN3952ZAtkins Ray H · Cantwell, AKN39539Sandia Aviation Services LLC · Albuquerque, NMN3953KRamsden Bruce A · Stillwater, MNN3953PSowards David C · Fairbanks, AKN3953QQueen Anne Air LLC · Seattle, WAN3953TUniversal Technical Institute Inc · Avondale, AZN3953ZMoore David W · Wasilla, AKN39540Sunset Adventures LLC · Conroe, TXN39546L A M Capital Management LLC · Sheridan, WYN39547Workman Dean B · Newport, RIN3954AVasil Christopher J · Los Gatos, CAN3954PUecker Garrett J · Holdrege, NEN3954RGlover Thomas B Jr · Marana, AZN3954XLeighty John P · Arlington, WIN3954YStone Clifford F Jr · Corning, CAN3954ZThompson Charles M · Pierre, SDN39551Lance 551 LLC · Bristol, INN3955PBent Prop Club LLC · Waverly, IAN3955XPabon Eduardo A · Granada Hills, CAN3955ZSipperley Bradford L · Fairbanks, AKN3956Hoyt Robert H Trustee · Canby, ORN39567Cleveland Aero Club Inc · Spring City, TN
Back to AD 2007-04-19 R1