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.
N42GVBlahnik Vance Thomas Trustee · Eden Prairie, MNN42HCRegistered aircraftN42HFKlochko Oleg Alexander · Furlong, PAN42HJSprenger Steven J · Fargo, NDN42HRHarmon John M · Bakersfield, CAN42HYJmfr Aviation LLC · Dallas, TXN42JAJersey Aero Club Inc · Lakewood, NJN42JTFiltersource LLC · Fort Collins, CON42JVCheshire Vincent Eugene Jr · Slidell, LAN42JWBusiness Aircraft Leasing Inc · Petersburg, ILN42KANorth Little Rock Air Inc · North Little Rock, ARN42KCChatham Kenneth W · Montross, VAN42KRDonnelly Charles A · Browns Mills, NJN42KSSink Kreth H · Scott Depot, WVN42KWMarine Aviation LLC · Lyme, NHN42LBRigney Timothy D · Troy, VAN42LDJaggers Aviation LLC · Tupelo, MSN42LFSodville Inc · Taft, TXN42LLGayden Marshall G · Wilmington, NCN42LMMorrison Mark C · Marfa, TXN42MASimply Living LLC · Fort Myers, FLN42MDN42md LLC · Ashburn, VAN42MMPiper Capital LLC · Elkhorn, NEN42MWWalker Winston W Trustee · Tucson, AZN42MXRed Baron LLC · Middletown, DEN42NCCapair Inc · Plantation, FLN42NTClennan Roy J · Colorado Springs, CON42NZCo Fire Aviation Leasing Inc · Fort Morgan, CON42PBPfister Mark A · Acworth, GAN42PEDennis Kevin M · Bend, ORN42PKBacon Robert J · Florence, MAN42PMJofredo Corp · Zephyrhills, FLN42PSPrewitt Scott S · King City, CAN42PZZeidman Richard B · Cape Coral, FLN42RGInternational Air Services Inc Trustee · Carson City, NVN42RHGet-U-There Air LLC · Poplar Grove, ILN42RLChristiansen Aviation LLC · Wilmington, DEN42RRWalla Walla University · College Place, WAN42RYRagsdale Brent Nathaniel · Stockton, CAN42SGPolar Star Co · Wilmington, DEN42SMBaron South LLC · Dexter, MON42SPCw Air LLC · Broken Bow, NEN42SSBas Part Sales LLC · Greeley, CON42SWHolt Aviation LLC · Clear Lake, IAN42TBFlores Nicholas L Jr · San Antonio, TXN42TPBalkin John S · Bigfork, MTN42TVK2 Aviation LLC · Carroll, IAN42TWDavis Keith · Manchester, TNN42TYRisjan Randy D · Westfield, NYN42VAFault Line Flyers · Leander, TX
Back to AD 2007-04-19 R1