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.
N331MKStardust Aviation LLC · Farmingdale, NYN331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKN331NTCrowley E Ned · Londonderry, NHN331PEnglish Barton C · Liberty Corner, NJN331PAHale Enterprises Inc · Carbondale, ILN331PHAppel Raymond Lee · Incline Village, NVN331RDHiggins Roland · Solon Springs, WIN331RHWhite Wing Aviation LLC · Shreveport, LAN331RPRaritan Valley Flying School · Princeton, NJN331SPReinfeldt Phillip R · Burnsville, MNN331VRRoof Jerry G · Centennial, CON331WTillman Nickolas R · Piggott, ARN331WBAb Aviation LLC · Ashland, OHN3320DPara Tactics LLC · Shelton, WAN3320FPoock Jerry D · Spencer, IAN3320ZHolton Mark · Lebanon, MON33216Avarts LLC · New Castle, DEN3321CAviation Management II LLC · Des Moines, IAN3321FOwl Aviation LLC · Kingsport, TNN3321LN3321l LLC · Dacula, GAN3321MMaxray Aviation LLC · Ashland, OHN3321RGray Kerry L · Granbury, TXN3321TWilks Donald Leon · Flat Rock, ALN3321XPatton Aviation LLC · Billings, MTN3322DObrien Aviation LLC · Moreno Valley, CAN3322FCrystalline Entity · Los Angeles, CAN3322GLone Star Flight Museum · Houston, TXN3322KHamilton Roger A Trustee · Pisgah Forest, NCN3322UPrecision Design Inc · Wilimington, DEN3322WWilson Devin · Star, IDN3322XAllgood Michael K · Saint Augustine, FLN3322YFostair Inc · Ovid, NYN3323DPrince Christopher E · Anchorage, AKN3323FFly The Dream LLC · Sun Prairie, WIN3323MTalbot Larry · Bradenton, FLN3323RD&J Air Adventures Inc · Koloa, HIN3323TDeese James K Jr · Charlotte, NCN3323YMiellerie LLC · Bridgeport, TXN33247R House Leasing LLC · Stormville, NYN3324UHaer Welton · Craig, MON3324WThompson Mark D · West Chicago, ILN3324YVoge Michael · Chino Hills, CAN3325QWinrick LLC · Flagstaff, AZN3325RDresick Farms Inc · Huron, CAN3325UWeber Donald E · Saint David, AZN3325WGuzman Ronald Leonard · Salinas, CAN3326FRegistered aircraftN3326MMcray Brett H · Sugar Land, TXN3326PDean Marshall H · El Paso, TXN3326RAnderson Patrick Alan · Ripley, WV
Back to AD 2007-04-19 R1