AD 2007-01-06
Registered aircraft · 1,397
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-01-06')
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-01-06')
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-01-06') 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-01-06') 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.
N137AGTop Gun Precision Ag LLC · Skidmore, TXN137HSHelicopter Services Of Illinois LLC · Fisher, ILN137MScotts Helicopter Services Inc · Le Sueur, MNN137MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN137MSKansas State University · Salina, KSN138AEAir Evac Ems Inc · O Fallon, MON138DDDalton Aviation LLC · Bluffdale, UTN138LHHelilease LLC · Lewes, DEN13FBFirebird Holdings LLC · Fort Worth, TXN13HDHelicopters Inc · Wilmington, DEN13NNHelicopters Inc · Wilmington, DEN13QBFly Hangar 13 LLC · Mico, TXN1404WPendley Rory G · Torrance, CAN142DPMarks Lloyd · Lafayette, LAN1431WC-Pan Aero LLC · Stratford, CTN1435WFarwest Aviation LLC · Billings, MTN144BHAbc Helicopters Inc · Jefferson, WIN144TVAir Flite Inc · Shawnee, OKN145LTLt Aviation LLC · Louisa, KYN146SHScott'S Helicopter Services · Le Sueur, MNN146SPSamaritan'S Purse · Boone, NCN147AGTop Gun Precision Ag LLC · Skidmore, TXN14837Oscar Aerial Spraying LLC · Grady, OKN148KYCommonwealth Of Kentucky · Frankfort, KYN14SJAlternative Energies Corp · Beaver Island, MIN150F11 11 Enterprises LLC · San German, PRN150HHCascade Airways LLC · Jefferson, ORN1510LCity Of Dallas · Dallas, TXN1511LCity Of Dallas · Dallas, TXN152CAChem Air LLC · Shreveport, LAN155TVU S Helicopters Inc · Marshville, NCN156CAChem-Air LLC · Shreveport, LAN157PAPatriot Aviation Inc · Greenville, DEN157SJNorth Wind Aviation LLC · Cottage Grove, ORN158LHHelilease LLC · Lewes, DEN15FHD H Helicopter Inc DBA · Mascoutah, ILN15PSCb4 LLC · Wilmington, DEN160JAAg-Air Inc · Brent Alger, CAN161ACHelipato Corp · Lake Worth, FLN161SFGm Leasing Co LLC · Broussard, LAN164AETextron Financial Corp · Wichita, KSN164DMWcf Aerospace LLC · Madison, MSN164KMemphis Police Department · Memphis, TNN165AETextron Financial Corp · Wichita, KSN165JKBohica Consulting Services Of Nevada Inc · Boulder City, NVN16671Sarkinen Plumbing Inc · Portland, ORN166AETextron Financial Corp · Wichita, KSN166MSFlyone USA Corp · Miami, FLN16715Cahaba Forestry Services LLC · Flowood, MSN16726Aeroag Asset LLC · Edgerton, MO
Back to AD 2007-01-06