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.
N5004EGregorin Richard C II · Anchorage, AKN5004WN5004w LLC · Kansas City, MON5004YElon Aviation LLC · Burlington, NCN5005JDowding Industries Inc · Eaton Rapids, MIN5005LBlanton Jeffrey D · Valley Center, KSN5005PRackley William R Jr · Grand Island, FLN5005RBaer Michael E · Wheaton, ILN5005TWeekend Air LLC · Incline Village, NVN5005WManxhuka Dukagjin · Ridgefield Park, NJN50067Prop Wash Aviation LLC · Hayward, WIN5006DClosson Luke E Jr · Valdosta, GAN5006EPainter Harold R · Anchorage, AKN5006PWright William · Cleveland, OKN5006SOracle Aviation LLC · Omaha, NEN5006WWright Stephan T · Charlestown, INN5007SSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5007TLara Jess D · Albuquerque, NMN5007WPeters Mark M · Chandler, AZN5008Holmes John K · Spring, TXN50084Mid Atlantic Air Museum Inc · Reading, PAN5008CMckenna Kent T · Torrance, CAFirst renewal noticeN5008DDufriend Daren P · Payson, AZN5008JR C Construction Co Inc · Greenwood, MSN5008PThree Chicks Aviation LLC · Benton, LAN5008TS E D Air LLC · Kimball, SDN5008WZanier Aldo M · Long Beach, CAN5009QWeed Ryan W · San Francisco, CAN5009UOrca Flight LLC · Keaau, HIN5009WRegistration Pending · Americus, GARegistration pendingN500AFAmerican Air Academy Inc · Merritt Island, FLN500AKJones Thomas F · Boerne, TXN500AVInternational Air Services Inc Trustee · Carson City, NVN500AWMcnulty Kim E · Tehachapi, CAN500BAKw Plastics · Troy, ALN500BCGwinn Donald R · Mccall, IDN500BEAnders Robert · Deforest, WIN500BMHawkwell Aviation LLC · Stillwater, OKN500BSCentral Aircraft Sales And Leasing LLC · Columbia, MON500BWRaw Inc · Raleigh, NCN500CALegha Jaskirat · Holly Ridge, NCN500CHAchiro David P · Truckee, CAN500CMM & M Aviation LLC · Portsmouth, NHN500CTLac Aero LLC · Liberal, KSN500DGraham Douglas R · Palmer, AKN500DDDecramer Richard J · Webster, MNN500DMFive Delta Mike Inc · Wilmington, DEN500DPO'Rourke Lawrence · Montgomery, PAN500DRFox 2 Inc · West Chicago, ILN500DSBarletta Mark S · Winter Haven, FLN500DZEz Aviation LLC · Orlando, FLFirst renewal notice
Back to AD 2007-04-19 R1