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.
N514KKSchaperkotter Harold M Jr · Anchorage, AKN514LLLenahan Lawrence M · Scottsdale, AZN514LPInvader Aviation LLC · Tijeras, NMN514MCTurbo Aviation LLC · Chesterfield, SCN514MDPerez Pedro J · Mayaguez, PRN514MLPikes Private Planes LLC · Danville, KYN514MRDmc Holdings LLC · Bullard, TXN514MTTrede 2020 C172 LLC · Aurora, ORN514MWWalker Michael L · Fredericksburg, TXN514NCHyannis Air Service Inc · Hyannis, MAN514NDAerosim Academy Inc · Sanford, FLN514NYJones Christopher S · Twin Falls, IDN514PCParsons Donald E · Clarksville, TNN514PHRegistration Pending · Springfield, TNRegistration pending, pending cancellationN514RBOsprey Holding Company LLC · Foley, ALN514RMSobre Las Nubes LLC · Cocoa, FLN514SCSundance Aero LLC · Mertzon, TXN514SGBorland Equipment Leasing LLC · Midland, TXN514SMEleven Eleven Aviation LLC · Rockwall, TXN514TPactolus Investments LLC · Blounts Creek, NCN514TCChildress Anthony H · Frisco, TXN514TDDay William B · Conroe, TXN514TFFusco Todd S · Durant, IAN514WCassill Aircraft Leasing · Cedar Rapids, IAN514WJFinke Andy · Lake Geneva, WIN514ZCHusky Leasing LLC · Helena, MTN514ZSSoutheast Aviation · Anchorage, AKN5150Hlavac Mathew B · Ramona, CAN5150DTap Solutions Inc · San Diego, CAN5150EM & M Aviation Enterprises LLC · Springfield, MON5150PPeterson Richard A · Entiat, WAN5150UMolina Monreal Angel Humberto · Sahuarita, AZN5150WDunn Scott A · Morris, ILN51515Wolfe Douglas S · Yucaipa, CAN5151EBlhh · Dixon, CAN5151JHalverson Mechanical Inc · Ogden, UTN5151PHone Ryan L · West Richland, WAN5151QNotsa LLC · Morrison, CON5151RLuszczek Christopher L · Berkshire, NYN5151XBazer Thomas E · Petersburg, AKN5152QB & L Property Holdings LLC · Brush Prairie, WAN5152RAero Marine LLC · Denver, NCN5152SHarrier Aviation LLC · South Saint Paul, MNN5152WDavis Gordon · Lexington, KYN5153DFree Fall Gulf LLC · La Grange, TXN5153LUntil We Fly Away LLC · Orlando, FLN5153PCjl Aviation LLC · Dover, DEN5153RVogel Todd J · Bishop, CAN5153SSierra Flying Club · Buckley, MIN5153TChampion Phyllis W · Reno, NV
Back to AD 2007-04-19 R1