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.
N28098Cae Aviation Academy Phoenix LLC · Mesa, AZN2809CNixon Ross M · Hillsboro, ORN2809ENorth Marin Air LLC · Petaluma, CAN2809FOverbaugh Gary R · Highland, UTN2809PDavis Gerald R · Hernando Beach, FLN2809RTerwillegar Charles E · Renton, WAN2809XGuckian Jim J · Riverdale, GAN280AL2e2 Corporation · Menlo Park, CAN280AASchurr Steven M · Nederland, CON280AGWings Over Texas Holdings LLC · Denton, TXN280ASBravo Aviation Club LLC · Cary, NCN280BGD&J Aviation LLC · Gotha, FLN280CABlue Skies Flight Club LLC · Cameron Park, CAN280CDWelling Lynn E · El Cajon, CAN280CSYolo Farms LLC · Raleigh, MSN280DABouffard Marcel · Flowery Branch, GAN280ERNew Course Aviation Co · Golden, CON280FGFox Leasing Group LLC · Hollywood, FLN280FSAirflight LLC · Wilmington, DEFirst renewal noticeN280GACavanaugh Flying Service Inc · Minden, NEN280HB280hb LLC · Brighton, MIN280HGGeorgia Aviation Authority · Eastman, GAN280HRMussen Gary L · Exeter, CAN280JAFlying Tigers Flight School Ltd · Houston, TXN280JGEdwards Jonathan S · Marysvale, UTN280JPDraaisma Jacob Jr · Middleville, MIN280JSStefanini Joseph M · Akron, OHN280LVagiunic David · Ridgewood, NYN280LASeipp Stephen C · Laurel, DEN280MMrr Spraying LLC · Shelby, MTFirst renewal noticeN280MAMcgarity Daniel Scott · Essex, MON280MLLundy Michael · Stephenville, TXN280MSM & S Air Service Inc · Honeoye Falls, NYN280NARohner Harlan G · Willmar, MNN280PEBravo Leasing LLC · Daytona Beach, FLN280PTAzure Leasing LLC · Oakdale, PAN280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYN280SEKennicott Wilderness Air LLC · Boonton, NJN280SHRottor Aviation LLC · Jasper, INN280SMAirpark Aviation LLC · Manchester, NHN280SUOhio State University · Columbus, OHN280SWKatie Investments Inc · Little Rock, ARN280TCNobles Gary D · Fairview, TXN280UOhio University · Athens, OHN280WLWalloon Air LLC · Oakwood, OHN280YSCrabtree Martin L · Sedalia, MON28103Hawksyntketics LLC · Jacksonville, FLN28106Adams Charles J · Santa Maria, CAN2810AWiggin Connery A · Lakeside, MTN2810FDancing On Blue Lc · Las Vegas, NV
Back to AD 2007-04-19 R1