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.
N3876SMustoe William J Jr · Summersville, WVN3877JWilson Steven J · Elkton, KYN38787Onawa Flying Service · Sioux City, IAN3878HGregory Vernon L · Swansea, SCN3878KQualitair LLC Trustee · MichelstadtN3878LLatshaw Sonja · Vero Beach, FLN3878RSs Farms Operating LLC · Hydro, OKN3878SSkyhawk172 LLC · Gainesville, TXN38794Shealy Charles T · St Helena Is, SCN3879JMuehl John M · Maryland, NYN3879LThielemann Kate Ann · Inverness, FLN387RMHeil Joe · Edgar, WIN3880KRhodes Tracy · Reno, NVN3880RC172 Nancy LLC · Euclid, OHN3881LDarnell David M · Bon Aqua, TNN3881SWynja Loreen Dee · Riverside, CAN3882JPeek James · South Fork, CON3882SNichols Troy · Clinton, ARN38837Taylor Lucas S · Watford City, NDN3883LBragg Gary W · Rainelle, WVN3883RGingras Carl A · Avondale, CON3883SBruns Scott A · Brodhead, WIN38846Danforth Byron F · Fryeburg, MEN3884LCosta Jason L · Spring Hill, FLN3884SHawley Michael C · Hampton, NHN3884YJohnson James R · Cedarville, OHN3885KFlies Warren E · Mesa, AZN3885SLewis Kyle P · Shelbyville, KYN3886LRench Eugene G · Owosso, MIN3887KWaters Joseph P · Morganton, NCN3887LHigley Ryan · Arlee, MTN38880Shrader Sarah L · Rhinelander, WIN38881Bishops Ltd · Virginia Beach, VAN3888HLewis James T Jr · Williamsport, MDN3888JAzalea Aviation LLC · Quitman, GAN3888RGriswold Zachary S · Waunakee, WIN3889JVeduccio Gary Robert · Griffin, GAN3889KBohl Howard M · Temecula, CAN3889LBaker Duane · Shepherd, TXN3889RAdams Donald C · Garner, NCN388DTSchool Street Design Co LLC · Aptos, CAN388SESunset Eagle Aviation LLC · Southport, FLN3890LTexas Yellow Rose Planes LLC · Fort Worth, TXN3890RWright Chad · Fredericktown, OHN3891RN3891r LLC · Ogden, IAN3892EFerriter John M · Waterville, NYN3892HDezso Joseph A · Arroyo Grande, CAN3892LHuettl Austin · Liberty Hill, TXN3892SState Technical College Of Missouri · Linn, MON38946Vierra Daryl M · Tempe, AZ
Back to AD 94-05-05 R1