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.
N3FHScarborough Alex C · Lubbock, TXN3FNFreedom Wings LLC · Spout Spring, VAN3FPJohn Nathan · Prescott, AZN3GMeloche Michael S Trustee · Hamilton, MTN3GFRhoads Timothy C · Logan, NMN3GPAerospace Museum Of California · Mcclellan, CAFirst renewal noticeN3HERidgemont Real Estate Inc · Huntington Woods, MIN3HFHughes Farms Inc · Fayette, MON3HKInternational Air Services Inc Trustee · Carson City, NVN3HNDraper Floyd Lawrence · El Paso, TXN3HRDow Glendal R Trustee · Bedford, TXN3HVJoseph Matthew · San Rafael, CAN3JARegistered aircraftN3JFBruegget Shannon B · Lance Creek, WYN3JKPagenkopf Joseph C · Juneau, AKN3JPMcbride Scott · Lake Havasu City, AZN3JUUrgo James T · Carmel Valley, CAN3JWJason Flood · Vineland, NJN3KBJobe Dwaine B · Chilhowee, MON3KKKraussman Daniel J · San Antonio, TXN3KMStevens Burton G · Las Vegas, NVN3KNKing Martin E · Friendswood, TXN3KPAllied Asset Management LLC · Oklahoma City, OKN3KXMarathon California Holdings Lp · San Diego, CAN3LMManary Lowell A · Montrose, CON3LNAllen Jeffrey W · Crestwood, KYN3LWKyllar LLC · Madison, WIN3MDMcdavid James J · Weatherford, TXN3MJLarsh Steven S · Libby, MTN3MSCarter Zac · Atlanta, GAN3MUAero Equities LLC · Ventura, CAN3MVVia Mikael W · Camarillo, CAN3MWDantonio David · Wichita Falls, TXN3MYLee Brian E · Peoria, AZN3NEPatton Ronald V · Marion, TXN3NFRooster Partners LLC · Santa Monica, CAN3NLBaez Rafael · Stafford, VAN3NQKropp Matthew M · North Creek, NYN3NUNystrom John L Jr · Albuquerque, NMN3PEJabr Aviation LLC · Milford, IAN3PFTuinstra Aaron C · Marinette, WIN3PKJohnson Marlon · Los Angeles, CAN3PLCarlin Bernard T III · Norman, OKN3PMEwing John L Jr · Yuma, AZN3PRShadow Air LLC · Mountain Home, ARN3QASg&F LLC · Riverside, CAN3QCLeonard Charles J · Apalachicola, FLN3QRKittridge Gordon · East Corinth, VTN3QTNew World Enterprises Inc · Aiken, SCN3QWPorterfield Bruce A · Reno, NV
Back to AD 2007-04-19 R1