Registered aircraft · 108,433

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

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

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.

N2109NStallings Farms Trucking LLC · Hertford, NCBuilt 1979 · S/N 28-7990274 N2109RVilt Jared J · Phelan, CABuilt 1964 · S/N 18255309 N2109TCarver Aero LLC · Muscatine, IABuilt 1971 · S/N 28R-7135055 N2109ZWoodward Richard B · Tallahassee, FLBuilt 1956 · S/N 21017 N210AAMeckley Sean H · Seattle, WABuilt 1982 · S/N 21064690 N210ABRudy Schmitt · Brookshire, TXS/N 21059209 N210ADUniplane Inc Trustee · Wilmington, DEBuilt 1967 · S/N 210-58835 N210ANCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17264678 N210APRegistration Pending · Wilmington, DERegistration pendingBuilt 1965 · S/N 21058713 N210ARVjc Air LLC · Katy, TXBuilt 1975 · S/N 21061077 N210ATTeeters David A · Salinas, CABuilt 1969 · S/N 21059186 N210AVCarter Jay Jr · Wichita Falls, TXBuilt 2013 · S/N 0002 N210AXKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 21063033 N210AZAerialtraders LLC · Estero, FLBuilt 1972 · S/N 21059678 N210BBCherry Hill Aviation C182 LLC · Freetown, INBuilt 1979 · S/N R18201430 N210BCDurant Bruno Gerard · Coalmont, TNBuilt 1998 · S/N 18280308 N210BESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P210-00088 N210BGTurner Kenneth W · Arlington, WABuilt 1978 · S/N P21000025 N210BHGlenn Wade Corp · Tucson, AZBuilt 1975 · S/N 21060954 N210BJSummers Equipment Leasing Inc · Wilmington, DEBuilt 1974 · S/N 21060221 N210BNBy Land Air And Sea LLC · Alto, MIBuilt 1974 · S/N 21060526 N210BPBbsc LLC · Wilmington, DEBuilt 1981 · S/N 21064300 N210BVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 21061114 N210BXNova Aircraft Holdings Inc · San Diego, CABuilt 1972 · S/N 21059583 N210CJettech Holdings LLC · Broomfield, COBuilt 1979 · S/N P21000218 N210CCMuller Rodolfo · Kerrville, TXBuilt 1978 · S/N 21063008 N210CEMaas Aviation LLC · Pewaukee, WIBuilt 1980 · S/N P21000563 N210CFQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 21063124 N210CHOne Up LLC · Stuttgart, ARBuilt 1974 · S/N 21060142 N210CKFann Robert P · Birmingham, ALBuilt 2003 · S/N L2K-148 N210CPToeppen Chris P · Atherton, CABuilt 1979 · S/N P21000230 N210CUTcl Fbo LLC · Tuscaloosa, ALBuilt 1981 · S/N 21064452 N210CWBeach Partnership LLC · Myrtle Beach, SCBuilt 1979 · S/N 21063595 N210CX210 Equipment LLC · Lexington, SCBuilt 1972 · S/N 210-59719 N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067 N210DCRrr Land & Cattle Co LLC · Midland, TXBuilt 1973 · S/N 21060159 N210DDDwoskin David F Trustee · San Pedro, CABuilt 1976 · S/N 21061464 N210DFHampton Harvey E · Simms, MTBuilt 1968 · S/N T210-0397 N210DGWashburn Stig K · Westminster, MABuilt 1972 · S/N 21059559 N210DLDaneco LLC · Houma, LABuilt 1978 · S/N P21000114 N210DRRaid Air LLC · Grand Rapids, MNBuilt 1978 · S/N 21063011 N210DSSevel Garry S · Fresno, CABuilt 1981 · S/N 21064275 N210DTNewell Gary · Colmar, PABuilt 2004 · S/N 23421 N210DWBlomberg Nicholas R · Macon, MOBuilt 1967 · S/N 21058876 N210EBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058365 N210EAFollis Allen J · San Tan Valley, AZFirst renewal noticeBuilt 1962 · S/N 21057973 N210EBBuell Jack A · St Maries, IDBuilt 1978 · S/N 21062568 N210EFDespain Aviation LLC · Pendleton, ORBuilt 1979 · S/N P21000391 N210EGCenturion Aviation LLC · Nokesville, VAS/N 21059133 N210ETVroom Consulting Inc · Ithaca, NYFirst renewal noticeBuilt 1968 · S/N 21059079

Back to AD 2007-04-19 R1