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.
N3530YScollon Brian F · Hudson, COFirst renewal noticeN3531Lippert Mark S · Collinsville, OKN35313Lyon W Bruce · Carterville, ILN35315Hubert Thomas D · Greenville, TXN35318Wings LLC · Scottsdale, AZN35319Yoder Electric Inc · Monticello, GAN3531YPetter David · Stuttgart, ARN35321Manuel Greg R · Pecatonica, ILN35322Vincent Zachary T · Saint George, UTN35323Bourdon Greg · Henniker, NHN35324Schuster Darin D · New Castle, DEN35326Harrison Keith D · La Grange, NCN3532AGuedon Aviation LLC · Natchez, MSN3532EDubois William C · El Centro, CAN3532LPiab Inc DBA · Fresno, CAN3532NMoorefield Charles N · Houston, TXN3532PBryan Curtis L · Enumclaw, WAN3532TNs Aviation Training And Rental Inc · Pembroke Pines, FLN3532XShipley James P · Los Alamos, NMN3532ZMurphy Michael R Trustee · Syracuse, NYN35330Wilkerson Jeffrey D · Morning Sun, IAN35332Katchmar Michael L · Canon City, CON35337Myer Martin John Trustee · Juneau, AKN3533MBrowning Gregory S · Deputy, INN3533YFarley Sean D · Anchorage, AKN3533ZSchwanebeck Derek D · Ellsworth, NEN35340Jones Donald E · Hollandale, MNN35344Sawyer James E · Urbana, OHN35345Flight One Holdings LLC · Devils Lake, NDN35348Jet & Rotor Aviation LLC · Sacramento, CAN35349Stammich Thomas R · South Bend, INN3534FLackie Paul C · Melbourne, FLN3534HBeatty Don K · Mount Ulla, NCN3534NCoffey Joseph · Camarillo, CAN3534QLeatherneck Aviation LLC · Billings, MTN3534WSmittys Garage LLC · Fairmount, INN35358N44344 LLC · Wasilla, AKN3535QBoulton Stephen A · Eugene, ORN3535XZulu Aviation Corp · Fort Worth, TXN35362Hicks James P · Franklin, OHN3536GGeorge'S Aviation Services Inc · Honolulu, HIN3536JSoronen Jack W · Berkeley Springs, WVN3536NWestern Fires Inc · Yoncalla, ORN3536XGreen William Robert Jr · Waller, TXN35370Dans Land LLC · North Little Rock, ARN35371Honrud Joseph C · Cal Nev Ari, NVN35377Laurel Highlands Aeronautical Academy · Latrobe, PAN3537BDulles Aviation Inc · Bristow, VAN3537FWatson James L · Burke, VAN3537JAtp Aircraft 2 LLC · Wilmington, DE
Back to AD 2007-04-19 R1