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.
N358YJuliet Air LLC · Cincinnati, OHN358ZMcrae Auto Corp · Jacksonville, TXN35909Flight1 Hsw LLC · Norwood, CON3590AHill Lonnie R · Gainesville, GAN3590PSoyars Thomas E · San Marcos, TXN3590WAgoston Thomas M Trustee · Liberty Twp, OHN3590YAlexander Macy Nix · Mineral Wells, TXN3591FWolfe Robert G · West Columbia, SCN3591NPeperuka LLC · Olympia, WAN3591RAwmr LLC · Conroe, TXN3592FArey Peter W · Great Falls, VAN3592KBeckler Benjamin C · Middle Granville, NYN3592PDengler Steven G · Lopez Island, WAN3592QCentral Arkansas Flying Club Inc · Bryant, ARN3592RBurnt Ridge LLC · Kalispell, MTN3592WFoothills Aviation Inc · Pickens, SCN3592XBryant David Wayne · Ada, OKN3592YArcher Donald B · Artesia, NMN35932Tmzk Holdings LLC-1 · North Fort Myers, FLN35937Glaser Don E DBA · Willow, AKFirst renewal noticeN3593FEakin Robert C · Franklin, PAN3593QKettunen Alan C · Ashtabula, OHN3593UBdg Holdings Inc · Kingston, PAN3593WGriffin Julie A · Locust Grove, GAN35945Illinois Department Of Transportation · Springfield, ILN35947Continental Construction Inc · Alpine, WYN3594AFlying Fur Animal Rescue · Kintnersville, PAN3594FFirst Flight Corp · San Diego, CAN3594JWxs Flying LLC · Mesa, AZN3594QGribble Ted A · Paris, TXN35952Johnson Deborah K · Fairbanks, AKN35957Cortez Flying Service Inc · Cortez, CON3595ALogistics Consulting LLC · Wilmington, DEN3595PSchumacher Craig A · Fairbanks, AKN3595UBrinkman Eric · Phoenix, AZN3595WStanley Shawn G · Lorton, VAN3595ZJohnson Issac · Krugerville, TXN35962Barker Aviation LLC · Spearfish, SDN3596KStall Breakers LLC · Sachse, TXN3596WAbdelqader Hamza Faris · Beaufort, SCN3596YHeintz Ludwig C · Covington, LAN3597EBlue Bird Aero Club Inc · Bonne Terre, MON3597FLivesay John · Pana, ILN3597KQuinn Knives LLC · Julian, CAN3597PBickford Tierra L · Big Lake, AKN3597YCraig & Craig LLC · Merrillville, INN3598UDunn Mark · Visalia, CAN3598WSwiss Eagles Inc · Las Vegas, NVN3599HSitter Duane A · Hayward, CAN3599YLooker Daniel M · Ferndale, WA
Back to AD 2007-04-19 R1