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.
N323EHBates Joseph E · Providence, UTN323ESAdams Samuel M · Anna, TXN323FWarden James L · West Milford, NJN323FLSch Aviation Inc Trustee · Sporle Kings LynnN323FSFredericks Hall Aviation LLC · Mineral, VAN323GBGs Aviation LLC · Lebanon, TNN323GSSpengler Gregg R · Potsdam, NYN323HGGulf State Aviation LLC · Tomball, TXN323HKTaylor Aviation Inc · Montgomery, NYN323HLLowman Harmon L III · Murchison, TXN323JLLeghorn Airfleet LLC · Columbus, INN323JMDubbert Roger D · Mexico, MON323JPWyatt Equipment Inc · Basin, WYN323JSCabe Joseph L Jr · San Antonio, TXN323KWBlue Cedar Aviation LLC · Raymore, MON323LMSandcastle Jwm Properties LLC · Paradise Valley, AZN323LPRkt Productions · Manassas, VAFirst renewal noticeN323MGRstv Inc · Dubuque, IAN323MWBoomerang Air LLC · Cedar Park, TXN323NDUniversity Of North Dakota · Grand Forks, NDN323PMSrc Property LLC · Alpine, TXN323PRSport Flying USA Services LLC · Lititz, PAN323RAStack Timothy A · Cataula, GAN323RCTigers Aviation LLC · Wasilla, AKN323SAPfister Patrick · Pinedale, WYN323SMAmerican Patrols Inc · Midland, TXN323TJGuardian Wings LLC · Fredericksburg, VAN323TPKohler Terry K · Lexington, SCN323TSKnippen Ronald M · Fort Jennings, OHN323TTRtw Adventures LLC · Post Falls, IDN323UShaneyfelt Samuel J · Shady Shores, TXN323VWSonoran Aero LLC · Phoenix, AZN323WWhitewings Aviation LLC · Milton, GAN323WBStaton Austin M · Soldotna, AKN323WTServices By Pps Inc · St George, UTN323YFYoo Investments Inc · Pharr, TXN32400Gilcher David L · Pioneer, OHN32403Blue Skies Flying Services Inc · Lake In The Hills, ILN32405Hop-Hi Aviation LLC · St Louisville, OHN32408Dalton Thomas C · Salem, SCN3240FJ Smith LLC · Lewes, DEN3240NAir Services Of Mississippi Inc · Mccomb, MSN3240SBenson Richard T · Bend, ORN3240TFrena John A · Pittsburgh, PAN32413Peterson Paul · Maryville, TNN32419Registered aircraftN3241PBravo Partners LLC · Payson, AZN3241RJohnson Edward Wayne · Bloxom, VAN3241TMaggart Daniel J · Winchester, ILN3241XLane Richard · Thomasville, GA
Back to AD 2007-04-19 R1