AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7729PPendergast Gary · Clermont, FLN7729YFogle Neil · Conroe, TXN772BDSmith Joy I · Mccall, IDN772CAChristiansen Aviation LLC · Wilmington, DEN772DMAmerican Aerial Imaging LLC · Fort Wayne, INN772EMelvin Daniel · Larkspur, CAN772EZSkylake Adventures LLC · Geneva, OHN772FGRidgeline Assets LLC · Wilmington, DEN772FTJazz Air LLC · Melbourne, FLN772GKAmerican Aircraft Brokers LLC · Aurora, ORN772HASmith Jason E · Calliham, TXN772JNBialek Joe · New Smyrna Beach, FLN772JTTinley Jim · Sandersville, GAN772KMGriffith Keith T · The Villages, FLN772LMKpk Holdings LLC · East Helena, MTN772LRMorris Charles R · Nampa, IDN772MESlow Walkin Barnstormers LLC · Frostproof, FLN772MSSchmidt Barnet M · Oradell, NJN772NDUniversity Of North Dakota · Grand Forks, NDN772RAKehmeyer Aviation LLC · Bronson, MIN772SFAcademy Aeronautique LLC · Mission Viejo, CAN772SHLawrence John · Anderson, CAN772TWBugden Michael S · Newnan, GAN772VBSkybone Airline Academy Inc · Vero Beach, FLN772WSSouthwest Technology Center School District No. 27 · Altus, OKN772ZZCirri Joseph A · Deming, NMN7730CBug'Z Land Clearing LLC · Pensacola, FLN7730PCox Paul G · Bryce, UTN7730WSuh Y H Charles · Rowland Heights, CAN7730ZRubbert Jan · Upham, NDN77319Dahlkamp Ethan R · San Diego, CAN7731NThompson Randy L · Anderson, CAN7731PSchwehm Karl E · Roach, MON7731VDedmon Stephen V · Fleming Island, FLN7732KReeves Figueroa Marion Richard · Newmarket, NHN7732PMckenney Michael P · Spring, TXN7732WWoodhead James R · Charleston, SCN7732YPurcell David S · Chandler, AZN7733GWashingtons Mt St Helens Co Inc · Mill Creek, WAN7733NS Dacy Enterprises Inc · Harvard, ILN7733PKeller Kevin M · Sylvania, OHN7733VLong Final LLC · Clay, NYN7733WSwyers Stinson R · Ottsville, PAN77340Slikker Enterprises Inc · Bakersfield, CAN7734CAstillero Ricardo · Northfield, NJN7734DPurcell Michael F · Ashfield, MAN7734JB & B Aviation LLC · Wilmington, DEN7734NStewart Duncan · Long Beach, CAN7734WBrown Tyler M · Cary, NCN7734YRussell R Bruce · Clayton, GA
Back to AD 81-18-04 R2