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.
N3960QLastochka LLC · Kalispell, MTN3960RLong William R · Jackson, TNN3960TThompson Jerry C · Goldsboro, NCN3960WTaylor Ryan · Lakeland, FLN3960YSeals Clinton F · Warren, ORN39610Archer Aviation LLC · Pittsburg, KSN3961MBluebird Aviation LLC · Bismarck, NDN3961PMcquivey David · St George, UTN3961RWhite Lightning 3961r LLC · Chandler, AZN3961TMartin Noah R · Newcastle, CAN3961YSmith Edward C · Lecompton, KSN39621Zulu Aircraft Leasing LLC · Grants Pass, ORN39626Drm Air Group Inc · Lewes, DEN3962DMalone Parachute Club Inc · Williston, VTN3962GJoe Sanchez Farms Inc · Walnut Grove, CAN3962KFolsom Lawrence E · Millington, MDN3962QKalstrom William M · Ekalaka, MTN3962RNifong James · Enterprise, ALN3962TSilvretta LLC · Kalispell, MTN39633Sandusky Aviation LLC · Edmond, OKN3963DMaplewood Flying Association Inc · Dorset, VTN3963TBlessing Stephen L · Bethany, MON3963ZMusgrove Jimmy Wayne · Delta Junction, AKN39647Pcl2 LLC · Menomonie, WIN3964NListowski John Paul · Galveston, TXN3964PWard Scot · Belgrade, MTN3964RPerrin Gregory R · Vail, AZN3964TFisher Joseph A · Conway, ARN3964WScheineman Wayne · Conroe, TXN3965PSlaughter Don Wayne · Farmville, NCFirst renewal noticeN3965RRamsey Brian D · Van Nuys, CAN3965THudgin Louis B · Gilbert, AZN3965XDevore Randall F · Prescott, IAN3965ZHarmon James E · Eagle River, AKN39669Lane Community College · Eugene, ORN3966RBless Edward L Trustee · Hollister, CAN3966ZLorence James E · Glennallen, AKN3967KLakes Area Aero LLC · Pelican Rapids, MNN3967QPeterson Dennis E · Cambridge, MNN3967UKarduck Craig J · Kingsville, TXN3967YBas Part Sales LLC · Greeley, CON39688N39688 LLC · Provo, UTN3968DFallon Jeffrey C · Berlin, MAN3968KOzdogan Brent · Lawrenceville, NJN3968NJohnson David E · Sunfish Lake, MNN3968QTundra Wings Ministries · Wasilla, AKN3968TService Oriented Aviation Readiness (S O A R) · Bolivar, MON3968WDiamond C Aviation Llcj · Gentry, ARN3968YDetray Michael S · Roy, WAFirst renewal noticeN39697Goldsmith Ronald R · Mansfield, TX
Back to AD 2007-04-19 R1