AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N221DNSeela Joel J · Nelson, MNN221FWallin Joshua M · Moreno Valley, CAN221MWWood Mark A · West Windsor, VTN221NJKowall Stephen J · Elgin, ILN221RLittlefield Floyd E · Centre, ALN221VHBramson Barry R · Shasta Lake, CAN221VJDucker Frank C · Los Gatos, CAN22203Koenig William J · Benedict, MDN22208Lamb Ryan C · Munster, INN2220VHarland Gary · Tuscumbia, ALN22210Registration Pending · New River, AZRegistration pendingN2221DChestnut Ridge Construction Inc · New Alexandria, PAN2221VStone Wall Acres · Antigo, WIN22226Orr Monte L · Hay Springs, NEN2222DAsbury Charles E · Valley Center, KSN2222ECowels Richard L · Plainwell, MIN2222WJohnson Linzy A · Lake Stevens, WAN2223KLopresti Stephen A · Marlborough, CTN22243Crawford Stephen E · Corinth, TXN22245Vanderploeg Connie · Edmond, OKN2224EReiss Dennis · Wilcox, NEN2224J24j LLC · Driggs, IDN2224VSokol Dennis A · Milan, OHN22250Rush Christopher C · Anchorage, AKN22251Barber Michael L · Igo, CAN22252Heid Nathan E · Nevada, OHN22253Blue Sky Investments LLC · Fayetteville, NCN22255Rodcon Aircraft Sales LLC · Kalispell, MTN2225BGrove Robert L · Boerne, TXN2225KJohnson Brian O · Alexandria, VAN2225VNebrig Kenneth J Trustee · Prescott, AZN22260Arnold James R · Latrobe, PAN2226VPrince Benjamin D · Lincoln, MTN22276Ramsey Lenny J · Greeneville, TNN22277Gage Rodney L · Oak Grove, ARN2227NMakotyn Andrzej · Northbrook, ILN2227VWingnut Inc · Wilmington, DEN22284Fenton Ted P · Rushville, MON22285Barlow Richard B · Stockbridge, GAN2228VZerener Mark A · Wichita, KSFirst renewal noticeN22297Trissell Flying Service Inc. · Clarksville, TXN2229BLaperle James · Greenville, CAN2229DN2229d LLC · Wilmington, OHN2229KProffett Paul G · Jupiter, FLN222FDKent State University · Stow, OHN222NBarber William A II · Newmarket, NHN222PMennenga Michael J · Ocala, FLN222PAFrank Eric A · East Troy, WIN222PNThomas Lawrence W · Rock Hill, SCN222QAKlopotek Jerome P · Orangevale, CA
Back to AD 94-05-05 R1