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.
N515XCPlane Fun Inc Tr (Trustee) · Snellville, GAN5160Historic Aircraft Restoration Museum · Maryland Heights, MON5160DPatton Jay A · Hobbs, NMN5160ELeading Edge Flight Academy LLC · Bend, ORN5160JZemnickas William V · Metamora, MIN5160LMikesell Bruce A · New Madison, OHN5160RTownley Wren Adam T · Orwell, VTN5160SJohnson Matthew N · Redgranite, WIN5160TBeaver Enterprises Inc · Wilmington, DEN5160XCulver Deborah M · Anchorage, AKN51614Stillwater Flyers LLC · Columbus, MTN51616Stardust Aviation LLC · Farmingdale, NYN5161DKnutson Wayne R · Thompson, NDN5161LGonzalez Ramiro Z · Homeland, CAN5161MSamora Bobby · Corona, CAFirst renewal noticeN5161NLewis Justin R · Frederick, OKN5161PN5161p LLC · Upland, CAN5161SCapen Leasing LLC · Palm City, FLN5161USkyler Aviation · San Diego, CAN5161XSlease Brian D · North Pole, AKN51627Warren David T · Mobile, ALN5162DRodrigues George C · Aiken, SCN5162FLosasso Michaela Marie · Scottsdale, AZN5162LBlue Gecko LLC · Sheridan, WYN5162MCorcoran Thomas A · Braintree, MAN5162PHorton Melody A · Diamondhead, MSN5162REllis Harvey Airport Inc · Guthrie, OKN5162SStramer Douglas W · Hazelton, NDN51635Kovaleski Thomas J · Chugiak, AKN51637South Dakota State University · Brookings, SDN5163DHaddix Stanley D · Hagerhill, KYN5163HLsn Air LLC · Morrison, CON5163JQuantie Harold · Locust Grove, OKN5163LBowyer Richard A · Ormond Beach, FLN5163PReynolds David A · Blacksburg, VAN5163SValley Fliers Flying Club · Auburn, WAN5163THendrickson Duane J · Rocklake, NDN5163UValor View Aviation LLC · Midland, TXN5163VKopacz Thomas · Glen Flora, WIN5163WSeaton Ryan W · Savannah, TNN5164EWilliams Kevin J · Giltner, NEN5164FBarr Air Patrol LLC · Mesquite, TXN5164MChristiansen Aviation LLC · Wilmington, DEN5164NCaribbean Way Of Life Inc Trustee · Wilmington, DEN5164PUpton John B · Lakeland, FLN5164SNorthern Sky Aviation LLC · Harbor Springs, MIN5164WMorning Aviation LLC · Altoona, PAN51659Hawk Robert S · Argyle, TXN5165DHull Terri L · Weirsdale, FLN5165JPeak Wings LLC · Missoula, MT
Back to AD 2007-04-19 R1