Skip to content

AD 2007-03-17 R1

Registered aircraft · 999

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-03-17-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-03-17-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-03-17-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-03-17-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-03-17-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-03-17-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.

N975CAAlfonso Aviation Holdings LLC · Tampa, FLBuilt 2010 · S/N 544 N975TBMiles High Flight Assets LLC · Atlanta, GABuilt 1993 · S/N 75 N975WWTrc 125 LLC · Punta Gorda, FLBuilt 2022 · S/N 1439 N976CMCmr Aviation LLC · Markesan, WIBuilt 2022 · S/N 1406 N977CAN977ca LLC · Kansas City, MOBuilt 2022 · S/N 1423 N977MDJt Aviation Group LLC · Wichita, KSBuilt 2020 · S/N 1356 N978AHMwp Of Delaware LLC · Camden, DEBuilt 2024 · S/N 1559 N979MBSs Consulting LLC · Lubbock, TXBuilt 2015 · S/N 1092 N980AXLon Aviation LLC · Aspen, COS/N 1633 N980BK537r LLC · Lake Havasu City, AZS/N 1648 N980CKAs Aviation LLC · Hartland, WIS/N 1644 N980DHTransatlantic Deliveries Trust · Wilmington, DES/N 1630 N980DVTransatlantic Deliveries Trust · Wilmington, DES/N 1672 N980EBJbjtbm LLC · Philadelphia, PABuilt 2026 · S/N 1627 N980EKHermes Hanger LLC · Phoenix, AZS/N 1628 N980EYTransatlantic Deliveries Trust Trustee · Wilmington, DES/N 1658 N980FPElj Northwest Inc · Aurora, ORS/N 1653 N980FRRegistration Pending · Tulare, CARegistration pendingS/N 1642 N980GMMcgrath Air LLC · St Charles, ILBuilt 2026 · S/N 1632 N980GPSpyglass Capital Holdings LLC · Wilmington, DES/N 1649 N980GTRegistered aircraftN-number assigned (import), not yet registeredS/N 1681 N980MMRegistration Pending · Helena, MTRegistration pendingBuilt 2026 · S/N 1638 N980MREquipment Services Corp · Wahpeton, NDS/N 1645 N980NETransatlantic Deliveries Trust Trustee · Wilmington, DES/N 1677 N980NPInnovation Transportation Inc · South Chesterfield, VAS/N 1652 N980PLTransatlantic Deliveries Trust · Wilmington, DES/N 1675 N980PRTransatlantic Deliveries Trust · Wilmington, DES/N 1665 N980SA960 Inc Trustee · Wilmington, DES/N 1655 N980SMMuncie Aviation Co · Muncie, INS/N 1663 N980SNAnazco Trans Air LLC · Warren, NJS/N 1651 N980THTransatlantic Deliveries Trust · Wilmington, DES/N 1674 N980VHRegistered aircraftN-number assigned (import), not yet registeredS/N 1683 N980VMRegistration Pending · Menasha, WIRegistration pendingS/N 1654 N980XFreedom Flight Group LLC · Prague, OKS/N 1639 N988APBff Enterprises LLC · Helena, MTBuilt 2023 · S/N 1502 N988CPegasus LLC · Fargo, NDBuilt 2003 · S/N 282 N989FBAeronautical Survey Systems LLC · Sarasota, FLBuilt 2014 · S/N 1039 N989PRN989pr Inc Trustee · Wilmington, DES/N 467 N98MAWell Equipped LLC · Sherman, CTBuilt 2018 · S/N 1254 N98NFTanner Air LLC · Oxford, MSBuilt 1998 · S/N 133 N990MEBonita Resources LLC · Bonita Springs, FLBuilt 2023 · S/N 1466 N993WCBravo Tango Partners LLC · Carmel By The Sea, CABuilt 2006 · S/N 355 N994DF5 Blade Aero LLC · Firestone, COBuilt 1991 · S/N 22 N997JMLight Aircraft Leasing LLC · Menomonie, WIBuilt 2003 · S/N 244 N999TAIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2012 · S/N 611 N99CXCobra Kai Inc · Lawton, OKBuilt 2005 · S/N 324 N9CMMaloney Leasing LLC · Tupelo, MSBuilt 2025 · S/N 1573 N9EECarolina Real Estate Consultants LLC · Pickens, SCBuilt 2003 · S/N 286 N9UEDakota Commercial & Development · Grand Forks, NDBuilt 2002 · S/N 224

Back to AD 2007-03-17 R1