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.
N32488Registered aircraftN3248DPalmer Cade E · Eagle River, AKN3248LPreferred Management Corp · Shawnee, OKN3248PAero Spectra Corp · Boulder, CON3248SHanson Glen W · Anchorage, AKN3248TBrydon Robert J · Austin, TXN3248WKeifer Ronald C · Port Orange, FLN32490Jackson Charles A · Winchester, KYN32492Doyle Dylan D · Cerrillos, NMN3249DBielanski Allan · Larkspur, CON3249FRoberto Jeffrey M · Piscataway, NJN3249JSelge Leasing Inc · Niles, MIN3249UHutchison Roger R · Sioux Falls, SDN3249WMountain West Aviation LLC · Albuquerque, NMN324ALauridsen Hans O · Scottsdale, AZFirst renewal noticeN324AKKeiser John T · Santa Fe, NMN324BBN324bbjf Inc Owner Trustee · Wilmington, DEN324BHN324bh LLC · Roanoke, VAN324CFerris Ryan P · Rochester, NYN324CADrakes Landing Inc · Archibald, LAN324CPCivil Air Patrol · Maxwell Afb, ALN324CSBrush Country Helicopters LLC · Laredo, TXN324DBush David M · Englewood, CON324DBDaugherty Warren F Jr · Jonestown, PAN324DHWood Thomas E · Sherrills Ford, NCN324DNFluckey Craig · Plattsmouth, NEN324EAWaytack LLC · Bryant, ARN324GIsle Air LLC · Danbury, CTN324GT324 Aviation LLC · Cavour, SDN324MARollings Hills Aviation Inc · Pelham, GAN324PTPlanedocs LLC · Spearfish, SDN324QLove Charles Keith · Asheville, NCN324RHPhillips William L Trustee · E Hampton, MAN324RJSchelhorn Timothy J · Nampa, IDN324RPClear For Take Off LLC · Burlingame, CAN324RVAmsa Jet Crew Solutions LLC · Windermere, FLFirst renewal noticeN324SVDavis Kyle R · Colleyville, TXN324TAIslander Holdings Ltd · Fort Lauderdale, FLN324TSDes Moines Flying Club LLC · Indianola, IAN324WCSebastian Charles J · Baytown, TXN324XFontenot Ira Dean · Collierville, TNN324YCesscon LLC · Yalesville, CTN324ZHannon Jim H · Cumming, GAN32500Fairfield Flying Service Inc · Fairfield, IAN32501Meives Mark J · Barneveld, WIN32505N83at LLC · Dover, DEN32506Schuhler Louis A · Plainfield, ILN3250FMantissa Corporation · Charlotte, NCN3250JHigh Mesa Aviation LLC · Naturita, CON3250U50 Uniform LLC · Traverse City, MI
Back to AD 2007-04-19 R1